28,391
社区成员
发帖
与我相关
我的任务
分享
Select * from (select 0 as type,* from YourTable where 是高级会员的新闻
union all
select 1 as type,* from YourTable where 是普通会员的新闻) as a
order by type asc,fdcreateat desc
<%
do while not rs1.eof or rs2.eof
if not rs1.eof then
response.write(rs1("***"))
rs1.movenext
end if
if not rs1.eof then
response.write(rs2("***"))
rs2.movenext
end if
loop
%>