<%
Response.Buffer = True
Function Show()
Randomize
RandNum = Int(Rnd * Ialt) + 1
Record.MoveFirst
For i = 1 to RandNum - 1
Record.MoveNext
next
Response.Write "<a href='
http://" & Record("http") & "'><img src='" & Record("banner") & "' alt='" & Record("info") & "' border = '0'></a><br>"
Response.Write "<center><a href='
http://" & Record("http") & "'><font face='Verdana' color='FFFFFF' size='2'>" & Record("tekst") & "</center></font>"
end function
Set Rs = Server.CreateObject("ADODB.Connection")
Rs.Open "databse sti (DNS less)"
banner1 = "Select count(*) as Found from tabelnavn"
Set Record = Rs.Execute(banner1)
Ialt = Record("found")
banner2 = "Select * from Banner"
Set Record = Rs.Execute(banner2)
%>
også nede på siden kalder jeg banneret ved hjælp af <% show()%>
men det skal være sådan at jeg kun viser bannere, der over holder felt1 <> felt2 og ikke felt1 > felt2
forstår du mig nu ???