如何从MYSQL表中显示3个随机值

Question

How would I go about displaying 3 random values each time a page is loaded? At the minute I have it displaying one at a time using the following code:

<?php
$sSQLQuery = "SELECT careername FROM careers ORDER BY RAND() LIMIT 1";  
$aResult = mysql_query($sSQLQuery);  
$aRow = mysql_fetch_array($aResult, MYSQL_ASSOC);  
$sQuoteOfTheDay = $aRow['careername']; 
echo $sQuoteOfTheDay;   
?>

I have tried doing LIMIT 5 but that had no effect on the result. Thanks

Answer 1

You'll have to call mysql_fetch_assoc() again for every single record your are fetching.

So, use LIMIT 3 and then simply loop through the result set. Like this:

$sSQLQuery = "SELECT careername FROM careers ORDER BY RAND() LIMIT 3";  
$aResult = mysql_query($sSQLQuery);  
while($aRow = mysql_fetch_array($aResult, MYSQL_ASSOC)) {
    $sQuoteOfTheDay = $aRow['careername']; 
    echo $sQuoteOfTheDay; 
}

Refer to the manual page of mysql_fetch_assoc(). You'll find more examples there.