Random mySQL

[petenaylor]

Hi all

 

I am trying to write a piece of code that displays a random banner from a database. Here's my code:

 

(I am getting $bannerpage from the URL)

 

$getheaderads = mysql_query("SELECT * FROM header_banners WHERE id = (SELECT FLOOR( 1 + ( RAND( ) * MAX( id ) ) ) ) AND $bannerpage = 1 ORDER BY id DESC LIMIT 1");

 

It works OK without the $bannerpage in, but this determines which page to show it on. It also works if you remove the while random code, but then it'll only show one image.

 

Please help!

 

Many thanks

 

Pete

 

[WebStyles]

can you post some more info please?

at a glance it seems you're confusing $bannerpage with a database field name, seems you need something more in the lines of:

 

$getheaderads = mysql_query("SELECT * FROM header_banners WHERE `FIELDNAME` = '$bannerpage' ORDER BY RAND() LIMIT 1");

(change FIELDNAME to whatever you field is called)

 

but I don't know your database structure and you provided very little information, so I cant be sure.