petenaylor Posted August 6, 2011 Share Posted August 6, 2011 Hi all I am trying to write a piece of code that displays a random banner from a database. Here's my code: $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 who one image. Please help! Many thanks Pete Link to comment https://forums.phpfreaks.com/topic/244050-random-sql-query/ Share on other sites More sharing options...
darkfreaks Posted August 6, 2011 Share Posted August 6, 2011 why are you using backticks instead if single quotes Link to comment https://forums.phpfreaks.com/topic/244050-random-sql-query/#findComment-1253311 Share on other sites More sharing options...
petenaylor Posted August 6, 2011 Author Share Posted August 6, 2011 Not sure, how should I be using them? Link to comment https://forums.phpfreaks.com/topic/244050-random-sql-query/#findComment-1253333 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.