我是初学者,请教asp中数据库显示问题
这是我学习用的一个代码,显示出来是在一个数据一行,我想一行显示两个数据,该如何显示?请高手指教。小弟分不多,还请各位教下我,并告诉一下我原理。十分感谢。sub ShowSmallClass_Tree() if rsBigClass.bof and rsBigClass.eof then response.Write "栏目正在建设中……" else dim sqlClass,rsClass,strTree,BigClassNum,i,j rsBigClass.movefirst BigClassNum=rsBigClass.recordcount i=1 do while not rsBigClass.eof if i<BigClassNum then strTree="" else strTree="" end if sqlClass="select * from SmallClass where BigClassName=✀" & rsBigClass("BigClassName") & "✀ Order by SmallClassID" Set rsClass= Server.CreateObject("ADODB.Recordset") rsClass.open sqlClass,conn,1,1 strTree= strTree & "<table width=180 border=0 cellpadding=0 cellspacing=0>" strTree= strTree & "<tr>" strTree= strTree & "<td width=24 height=22>" strTree= strTree & "<div align=center><img src=Img/arrow_2.gif width=13 height=11></div></td>" strTree= strTree & "<td width=150>" strTree= strTree & "<a href=✀Product.asp?BigClassName=" & rsBigClass("BigClassName") & "✀>" strTree=strTree & rsBigClass("BigClassName") strTree=strTree & "</a></td>" strTree=strTree & "<td width=24 height=22> </td>" strTree=strTree & "<td width=150> </td>" strTree=strTree & "</td>" strTree= strTree & "</tr><tr>" strTree=strTree & "<TD height=1 colspan=2>" strTree=strTree & "<IMG height=1 src=img/1x1_pix.gif width=10></TD>" strTree=strTree & "</TR>" strTree=strTree & "</table>" SmallClassNum=rsClass.recordcount j=1 do while not rsClass.eof rsClass.movenext j=j+1 loop response.write strTree rsBigClass.movenext i=i+1 loop rsClass.close set rsClass=nothing end ifend sub我主要是想弄明白这当中的道理。呵呵。请高手指点。