这样的!做一个小论坛!代码如下:假如吴给段发送私聊!这样显示出来吴能看见,段看不见这是怎么回事?
sql="select * from DBstep.lt_dx where (username='"& name2 &"'or username='"& userid &"') and (dxname='"& name2 &"'or dxname='"& userid &"') order by dxid desc"
opendatabase conn,rs
rs.open sql,conn,3
i=0
do while not rs.eof
response.write rs("dxtest")&"<br>"
i=i+1
rs.movenext
loop
rs.close
conn.close
set rs=nothing
set conn=nothing
list.asp
userid=session("username")
name1=application("name")
UserList=application("UserList")
for i=1 to UBound(UserList)
length=len(userlist(i))-1
name2=left(name1,length+1)
next
sql="select * from DBstep.lt_dx where (username='"& name2 &"'or username='"& userid &"') and (dxname='"& name2 &"'or dxname='"& userid &"') order by dxid desc"
opendatabase conn,rs
rs.open sql,conn,3
i=0
do while not rs.eof
response.write rs("dxtest")&"<br>"
i=i+1
rs.movenext
loop
rs.close
conn.close
set rs=nothing
set conn=nothing