asp问题！
<table style="width: 641px; height: 391px" border="1"><tr>
<td rowspan="2" style="width: 33px">序号</td>
<td rowspan="2" style="width: 35px">教学服务站名称</td>
<td colspan="10" style="height: 30px">
<%=studykind %></td>
</tr>
<tr>
<td style="width: 14px; height: 176px">合计</td>
<%
set rs = Server.CreateObject("ADODB.RecordSet")
strSql="select sub.subject from studykindlist as st,subjectsys as sub"
strSql=strSql+" where st.studykindid=sub.studykindid and st.studykind='" & studykind & "' group by st.studykind,sub.subject"
rs.Open strSql,conn,1,1
do while not rs.eof
%>
<td style="width: 22px; height: 176px">
<%=rs("subject") %>
</td>
<%
rs.MoveNext
loop
%>
</tr>
<%
num=0
set rsStat = Server.CreateObject("ADODB.RecordSet")
strSub="select count(*) as number,st.studykind as studykinds,sub.subject as subjects,fdz.fdzname as fdznames from subjectsys as sub,fdzlist as fdz,studykindlist as st,stusignsys as stu"
strSub=strSub+" where stu.studykindID=st.studykindID and stu.subjectid=sub.subjectid and st.studykind='" & studykind & "' and fdz.fdzname='" & fdzname & "' and stu.signdate between '" & SYear & "' and '" & EYear & "' and stu.stu_level='" & stu_level & "'"
strSub=strSub+" group by st.studykind,sub.subject,fdz.fdzname"
rsStat.Open strSub,conn,1,1
response.Write rsStat.RecordCount
%>
<%
i=1
do while not rsStat.eof
%>
<tr>
<td style="width: 33px; height: 128px">
<%=i %>
</td>
<td style="width: 35px; height: 128px">
<%=rsStat("fdznames") %>
</td>
<td style="width: 14px; height: 128px">
<%=CInt(rsStat("number")+rsStat("number")) %>
</td>
<td style="width: 22px; height: 128px">
<%=rsStat("number")%>
</td>
</tr>
<%
num=CInt(num+rsStat("number"))
rsStat.MoveNext
i=i+1
loop
%>
<tr>
<td colspan="2" style="height: 105px">
总 计</td>
<td style="width: 14px; height: 105px">
<%=num %>
</td>
<td style="width: 22px; height: 105px">
<%=num %>
</td>
</tr>
</table>
这段代码运行后显示有问题，要让结果<%=rsStat("number")%>显示在同一行（不同列），但是它每行只显示一列
<%=rsStat("number")%>，这样就显示了好几行，但每行只有一列。。。
