这是main的文件
<%
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from lb where lbpx=10 or lbpx=12"
rs.open sql,conn,1,1
lbpx=rs("lbpx")
lbname=rs("lbname")
id=rs("id")
rs.close
set rs=nothing
%>
<body leftmargin="0" topmargin="0">
<table width="290" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<table width="289" height="131" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr valign="top" bgcolor="#FFFFFF">
<td height="23" colspan="2">
<table width="100%" height="23" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="bottom" background="images/tb_bg_<%=lbpx%>.gif"> <a href="showlb.asp?id=<%=id%>&lbname=<%=lbname%>" class="003"><%=lbname%></a></td>
</tr>
</table></td>
</tr>
<tr>
<td width="90" align="center">
<table width="90" height="90" border="0" cellpadding="5" cellspacing="0">
<tr>
<td width="80"><img src="lb_pic/<%=lbpx%>.gif" alt="<%=lbname%>" border="0"></td>
</tr>
</table>
</td>
<td class="tb3">
<%
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select top 10 * from message where lb='"&lbname&"' order by id desc"
rs.open sql,conn,1,1
while not rs.eof
if len(rs("name"))>10 then
n=left(rs("name"),10)&".."
else
n=rs("name")
end if
if i mod 2=1 then
zx_pic="v.gif"
zx="在线收看"
else
zx_pic="r.gif"
zx="在线收听"
end if
%>
<table width="100%" height="20" border="0" cellspacing="0" cellpadding="0" class="tb4">
<tr>
<td width="161" align="left" valign="bottom"> <a href="showmessage.asp?lbname=<%=lbname%>&id=<%=rs("id")%>" class="003" title="<%=rs("name")%>">·<%=n%></a>
<br> </td>
<td width="38" align="center" valign="bottom">
<%if rs("online1")<>"无" then%>
<a href="#" onClick="window.open('p.asp?online=online1&id=<%=rs("id")%>&full=0','','width=<%=rs("width")%>,height=<%=rs("height")+88%> scrollbars=no')" class="004"><img src="images/<%=zx_pic%>" alt="<%=zx%>" border="0"></a>
<%end if%>
</td>
</tr>
</table>
<%
rs.movenext
wend
rs.close
set rs=nothing
%>
</td>
</tr>
</table></td>
<td width="1" rowspan="2" background="images/line_bg.gif"></td>
</tr>
</table>
我调用到首页用<!--#include file="main.asp"-->
可是只能显示lbpx=10的
我想显示lbpx=10和12
两项的
该怎么改
改了好多都不行
[讨论]关于查询有点问题，高手帮我
