Need help with random image code

[outdoorxtreme1]

Could someone please tell me what I need to change or add to allow this script to display a new image weekly instead of every time the page is refreshed?

 

Thanks.

 

<? 
// Connect to the database 
mysql_connect ('localhost', 'username', 'password') ; 
mysql_select_db ('database_name'); 

// Edit this number to however many links you want displaying 
$num_displayed = 3 ; 

// Select random rows from the database 
$result = mysql_query ("SELECT * FROM links ORDER BY RAND() LIMIT $num_displayed"); 

// For all the rows that you selected 
while ($row = mysql_fetch_array($result)) 

{ 
// Display them to the screen... 

echo "<a href=\"" . $row["link"] . "\"> 
<img src=\"" . $row["image"] . "\" border=0 alt=\"" . $row["text"] . "\"> 
</a>" ; 
} 
?>

[jscix]

Setup a small table where you can store a timestamp and randomly picked image. then you'd just need to check check the timestamp of that table before calling your pick-a-random-image code.