Randomise SQL query

[petenaylor]

Hi all

 

I need to know how to randomise the below code so that it pulls one entry from the SQL at random every time the page is refreshed. Here's my code:

 

<?php
 $getleftads = mysql_query(" SELECT * FROM `left_advert_banners` ORDER BY id DESC");
 while ($showleftads = mysql_fetch_array($getleftads)) { ?>
      <a href="http://<?php echo $showleftads['url']; ?>" target="_blank">
      <img src ="images/banners/<?php echo $showleftads['image']; ?>" width="158" style="margin-bottom: 2px;" alt="<?php echo $showleftads['text']; ?>" title="<?php echo $showleftads['text']; ?>" />
      </a>
     <?php } ?>

 

Many thanks for your help

Pete

[anupamsaha]

I didn't test the following, but it should be something like this:

 

// FLOOR(1 + (RAND() * MAX(id)) is to randomly choose an 'id' from 1 (lowest) to MAX(id) (highest available)
$getleftads = "SELECT * FROM `left_advert_banners` WHERE `id` = (SELECT FLOOR( 1 + ( RAND( ) * MAX( `id` ) ) ) ) ORDER BY id DESC LIMIT 1