Sorting Rand Function

[golfinggod]

Hi

Can Anyone Fix This Rand Function, It Isnt Displaying Any Result.

$Fetchbanner = "SELECT * FROM banners order by rand() limit 1"; 

$Result = mysql_query($Fetchbanner); 

$Row = mysql_fetch_array($Result); 

$Bannerowner = $Row ['username'];

echo $Bannerowner;

Thanks

[keith73]

Originally posted by golfinggod
Hi

Can Anyone Fix This Rand Function, It Isnt Displaying Any Result.

$Fetchbanner = "SELECT * FROM banners order by rand() limit 1"; 

$Result = mysql_query($Fetchbanner); 

$Row = mysql_fetch_array($Result); 

$Bannerowner = $Row ['username'];

echo $Bannerowner;

Thanks [/B]

everything in the code looks ok. try checking the integrity of the results.

if ( !$Result ){
   print "ERROR: " . mysql_error();
} else {
    print mysql_num_rows($Result) . "<br>";
    foreach ( $Row as $key => $value ){
        print "$key = $value<br>";
    }
}

• keith

[rupertbj]

Try this:

$Fetchbanner = "SELECT * FROM banners ORDER BY RAND(NOW()) LIMIT 0,1";

Let me know how you get on.