% set rs=server.CreateObject("adodb.recordset") sql="select * from FriendLink where State=-1 and showon=1 order by id desc" rs.open sql,conn,1,1 if not rs.bof then Response.Write ("document.write(""
| "&rs("LinkName")&" | "");") rs.movenext if rs.eof then exit for next Response.Write ("document.write(""