通过username为什么两个表不能互联。。。
<%dim userid,rsUser,UserNum
userid=SafeRequest("id",1)
set rs=server.createobject("adodb.recordset")
rs.open "select * from [user] where userid="&userid ,conn,1,1
%>
<tr>
<td valign="top" bgcolor="#FFFFFF"> <br/>
<table width="95%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC">
<tr bgcolor="#FFFFFF">
<td width="20%" height="23"> 用户名称:</td>
<td width="80%"> <font color=#FF6600><%=trim(rs("username"))%></font></td>
</tr>
<%rs.close
set rs=nothing
%>
<%
set rs=server.createobject("adodb.recordset")
rs.open "select * from [orders] where username="&username ,conn,1,1
%>
<tr bgcolor="#FFFFFF">
<td height="21" colspan="2">名称:<%=trim(rs("goods"))%>123</td>
</tr>
<%rs.close
set rs=nothing
conn.close
set conn=nothing%>