php和sql随机值

Question

I have a php sql script that generates 5 different values from a database everytime that it executes.
I want those values tot change lets say once a month and not everytime the script runs.

My code is:

$sql = "SELECT * FROM table ORDER BY RAND() LIMIT 5";
$query = mysql_query ($sql, $connection) or die (mysql_error()); 
while(($row = mysql_fetch_assoc ($query))){ 
    echo "<center>".$row['emri']." ".$row['mbiemri']."</center>";
}

Could anyone help me?

Answer 1

rand(year(now())*100+month(now()))

should give you a different random number every month. The argument for the rand function rand(...) is the seed. This value makes the returned random value be the same series, if the seed is the same. The way I wrote it makes the seed be the same each month. (eg this month 201305)