I have a code which outputs some random words from my DB, it works very fine. Every time the URL is loaded the page refreshes with the new random words.
How can I change this query or code so new words are not loaded every time when the URL is refreshed? I would like them to refresh every 24 or 48 hours instead, but not every time.
I have been trying to code this, but no success so far.
Thanks for your help!
$result = mysql_query("select bizName,bizAddr,bizCity,bizZip,bizPhone from biz_cons WHERE bizState ='$bizState' AND bizLive='1' ORDER BY RAND() LIMIT 2");
$bizName = $r['Name'];
$bizAddr = $r['Addr'];
$bizCity = $r['City'];
$bizZip = $r['Zip'];
$bizPhone = $r['Phone'];
$row = mysql_fetch_row($result);
<?php echo $row;?>, <?php echo $row;?>, <?php echo $row;?>, <?php echo $row;?>, <?php echo $row;?>