28,391
社区成员
发帖
与我相关
我的任务
分享
<%keyword=request("keyword") '接收要查询的关键词
set rs=server.createobject("adodb.recordset")
sql="select * from (select news_id as id,news_title as title,'newsshow.asp?news_id=' as urlfile from news where news_title like '%"&keyword&"%' union all select art_id,art_title,'artshow.asp?art_id=' as urlfile from article where art_title like '%"&keyword&"%')as t order by id desc"
rs.open sql,conn,1,1
do while not rs.eof
response.write "<a href="""&rs("urlfile")&rs("id")&""">"&rs("title")&"</a><br>"
rs.movenext
loop
rs.close
set rs=nothing
%>
select 被投票人id字段 from vote
select * from users where id in (上面取出的被投票人id字段,注意去掉前后的逗号)