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 Quote 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 Quote 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? Quote Link to comment https://forums.phpfreaks.com/topic/244050-random-sql-query/#findComment-1253333 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.