欢迎您：222 您有(9) 条短信.
111 短信
222 短信

退出
为什么用下面哪个用户登录都显示9条短信 。
sf是是否型的，用来判断是否已经阅读过
<!--#include file="conn.asp"-->
<%
set rs=server.CreateObject("ADODB.Recordset")
rs.open "select * from [user]",conn,1,1
set rs1=server.CreateObject("ADODB.Recordset")
rs1.open "select count(*) as he from dx where sf=true",conn,1,1
%>
<%if session("name")<>"" then%>
<%response.write("欢迎您："&session("name"))%> <%response.Write("您有")%>(<a href="#" onclick="window.open ('dxck.asp', 'newwindow', 'height=240, width=480, top=0, lef t=0, toolbar=no, menubar=no, scrollbars=yes,resizable=no,location=no, statu s=no')"><%=rs1("he")%></a>)
<%response.Write("条短信.")%>
<%else%>
</div>
<p>
</p>
<form id="form1" name="form1" method="post" action="index1.asp">
<table width="27%" height="131" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFCC00" class="aaa">
<tr>
<td colspan="2"><div align="center">用户登录</div></td>
</tr>
<tr>
<td width="43%"><div align="right">用户名：</div></td>
<td width="57%"><label>
<input name="name" type="text" size="10" />
</label></td>
</tr>
<tr>
<td><div align="right">密 码：</div></td>
<td><label>
<input name="pwd" type="text" size="10" />
</label></td>
</tr>

<tr>
<td height="30"> </td>
<td><label>
<input type="submit" name="Submit" value="提交" />
</label></td>
</tr>
</table>
<div align="center" class="aaa"><a href="zc.asp">注册</a> </div>
</form>
<%end if%>
<%if session("name")="" then
else%>
<table width="15%" height="21" border="0" align="center" cellpadding="0" cellspacing="0" class="aaa">
<%do while not rs.eof%>
<tr>
<td width="47%" height="21"><%=rs("name")%></td>
<td width="53%"><div align="center">
<a href="#" onclick="window.open ('fs.asp?id=<%=rs("id")%>', 'newwindow', 'height=240, width=480, top=0, lef t=0, toolbar=no, menubar=no, scrollbars=yes,resizable=no,location=no, statu s=no')">短信</a>
</div></td>
</tr>
<%rs.movenext
loop%>
</table>
<div align="center" class="aaa"><a href="tuicu.asp">退出</a></div>
<%end if%>
</body>
</html>