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