Vis to tilfældige billeder som ikke må være ens?
Jeg bruge denne kode til at hente 2 banner frem på min side, men det samme billede må ikke vises, hvad skal jeg ænfre?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")
bannershows = (rsBanner("BANNER_SHOWS") + 1)
bannerCode = rsBanner("BANNER_CODE")
bannerCodeTrue = rsBanner("BANNER_CODE_TRUE")
set rsBanner = Server.CreateObject("ADODB.Recordset")
strSQLBanner = "UPDATE BANNER SET BANNER_SHOWS = " & bannershows & " WHERE BANNER_ID = " & bannerid
rsBanner.open strSQLBanner,strDNS
IF bannerCodeTrue <> 1 THEN
%>
'udskriver her bannerne
<td><a target="_blank" href="Redirect.asp?b_id=<%=bannerid%>"><img src="billeder/Banner/<%=bannerpic%>" width="176" height="58" border="0"></a> <a target="_blank" href="Redirect.asp?b_id=<%=bannerid%>"><img src="billeder/Banner/<%=bannerpic%>" width="176" height="58" border="0"></a></td>