<!--#include file="Conn.asp"--><%
type_id=request("type_id")
set rs=server.CreateObject("adodb.recordset")
SQL="SELECT top 10 * FROM table1 where isvalid=1 and projecttype_id=" & type_id & " order by hits desc"
rs.Open SQL,conn,1,1
do while not rs.eof
Response.Write("Document.write(" & rs("cName") & ")")
rs.movenext
loop%>
type_id=request("type_id")
set rs=server.CreateObject("adodb.recordset")
SQL="SELECT top 10 * FROM table1 where isvalid=1 and projecttype_id=" & type_id & " order by hits desc"
rs.Open SQL,conn,1,1
do while not rs.eof
Response.Write("Document.write(" & rs("cName") & ")")
rs.movenext
loop%>
Response.Write "<Script language=""javascript"">"
type_id=request("type_id")
set rs=server.CreateObject("adodb.recordset")
SQL="SELECT top 10 * FROM table1 where isvalid=1 and projecttype_id=" & type_id & " order by hits desc"
rs.Open SQL,conn,1,1
do while not rs.eof
Response.Write("document.write('" & Replace(rs("cName"),"'","\'") & "')")
rs.movenext
loop
Response.Write "</Script>
%>