smsnews.asp

admin/admin.asp是WAP的后台管理登陆页面

<%
dim rsne,pno1
set rsne=Server.CreateObject("ADODB.Recordset")
rsne.open "select phone from login where id='"& request("shouji") &"'",conn,1,2
pno1=rsne("phone")
rsne.close
set rsne=Server.CreateObject("ADODB.Recordset")
rsne.open "select ID from bbssms where pnumber='"& pno1 &"' and news=0",conn,1,2
if rsne.recordcount=0 then
response.write ""
else
response.write("<a href='sms.asp?shouji="&request("shouji")&"'>[您有" & rsne.recordcount & "条新留言]</a><br/>")
end if
rsne.close
set rsne=nothing
%>