Det er en mysql jeg bruger, men er ikke helt sikker på hvordan jeg kan lave en tilfældig "top2" som du siger. Jeg viser dig lige koden som jeg bruger til at udskrive det ene billede, måske du kan se hvordan det kan sættes ind der?
<%
set rsBanner = Server.CreateObject("ADODB.Recordset")
strSQLBanner = "SELECT * FROM BANNER WHERE BANNER_PLACE = 1 AND BANNER_STATUS = 1 "
rsBanner.open strSQLBanner,strDNS
IF NOT rsBanner.EOF THEN
DO UNTIL rsBANNER.EOF
looper = rsBanner("BANNER_RANDOM")
DO UNTIL looper = 0
streng = streng & ", "&rsBanner("BANNER_ID")&""
looper = looper - 1
teller = teller + 1
LOOP
rsBanner.Movenext
LOOP
arrbanner = Split(streng,",")
For t = LBound(arrbanner) to UBound(arrbanner)
Next
antal = (t - 1)
Randomize()
Random = int((antal * Rnd())+1)
bannerid = arrbanner(Random)
set rsBanner = Server.CreateObject("ADODB.Recordset")
strSQLBanner = "SELECT * FROM BANNER WHERE BANNER_ID = " & bannerid
rsBanner.open strSQLBanner,strDNS
bannerid = rsBanner("BANNER_ID")
bannerpic = rsBanner("BANNER_PIC")
bannerCodeTrue = rsBanner("BANNER_CODE_TRUE")
IF bannerCodeTrue <> 1 THEN
%>
<table width="176" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td bordercolor="#FFFFFF"><div align="center"><a target="_blank" onFocus="this.blur()" href="Redirect.asp?b_id=<%=bannerid%>"><img src="billeder/Banner/<%=bannerpic%>" width="176" height="58" border="0"></a></div></td>
</tr>
</table>
<%
ELSE
%>
<table width="176" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td bordercolor="#FFFFFF" height="60"><div align="center"><a href="
http://www.cure4design.dk" target="_blank"><img src="billeder/banner/C4D_banner.gif" border="0"></a></div></td>
</tr>
</table>
<%
END IF
%><%
END IF
%>