<%
' aXinNo1 主要功能是模糊查询
Set rshost=Server.CreateObject("ADODB.Recordset")
sql="Select * from FreeHost.FreeHost_HostProductlist where serverlistid=1 and hosttype like '%型' order by orderbyid desc"
rshost.open sql,conn,1,1
For i=1 to rshost.RecordCount
if not rshost.eof then
%>
<%
usermoney=rshost("usermoney")
if agentname<>"n" then
Set dsendmoney = Server.CreateObject("ADODB.Recordset")
Sql="Select * from FreeHost.FreeHost_Agent_user_price where prtype='虚拟主机' and username='"&agentname&"' and id="&rshost("id")&""
dsendmoney.Open Sql,conn,1,1
if not dsendmoney.eof then
usermoney=dsendmoney("usermoney")
end if
dsendmoney.close
end if
%>
<%=rshost("hosttype")%>
<%
if i mod 3=0 and i<>rshost.RecordCount then
response.Write("
")
End if
%>
<%
rshost.movenext
End if
next
rshost.close
Set rshost=nothing
%>