I'm using the following code to pull a random quote from my db.
$result = mysql_query ("SELECT quote,sourcename
FROM crc1.quotes WHERE view = '1'
ORDER BY RAND() LIMIT 0,1");
while ($row = mysql_fetch_array ($result)){
echo '<a class="whiteTextMd" href="index.php?p=quotes" alt="Click here to see what else members are saying about CRC"><b>"'.$row['quote'].'"</a></b>';
echo '<br/>-'.$row['sourcename'].'';
} //end while
It works on my WinXP Pro, IIS5.1 box, but not on the Linux host I use. Any ideas why this is not working?
