Daily random number seeding help

[shadowbq]

would anyone know how to change this to incorporate the current date produced by say mysql date function so that the thread is random seeded based on the date not the microsecond?

This is my current random function which changes every time you view it. (I need it change only everyday)

$numuser = mysql_query("select count(*) from qotd") or   

         die (mysql_error());   

while ($row = mysql_fetch_array($numuser))  

{  

$num2=$row['count(*)'];  

}  

mt_srand((double)microtime()*1000000);  

$rannum=mt_rand(1,$num2);  

Thanks 🙂

[shadowbq]

Grudgingly I have resorted to using a current day date call to compare the listing.. if someone knows how to use anything besides microtime I would love a reply..

non random list.. it is a merely a sequenced listed now..

	$LinksQuery = mysql_query("select count(*) from lotd") or   

           die (mysql_error());
	$no_of_links = mysql_result($LinksQuery,0);

$MetaQuery = mysql_query("SELECT * FROM lotd_meta") or   
       die (mysql_error());
$row = mysql_fetch_row($MetaQuery); 
$number_reached = $row[1];
$date_modified= $row[2];

// get the current day of the month (from 1 to 31)
$day_today = date("j");


if ($date_modified != $day_today)
{
	// we have reached the end 
	if ($number_reached >($no_of_links - 1))
	   {
		$number_reached = 1;
		$query3 = 'UPDATE lotd_meta SET date_modified = "'.$day_today.'", number_reached = "'.$number_reached.'"';
		mysql_query($query3) or   
                       die (mysql_error());
	   } 
	else 
	   {
    		// haven't reached the end 			// increment $number_reached
		$number_reached = $number_reached + 1;
		$query3 = 'UPDATE lotd_meta SET date_modified = "'.$day_today.'", number_reached = "'.$number_reached.'"';
	   	mysql_query($query3) or   
                  	   die (mysql_error());
	   }
}

// we get the quote with 'id = $number_reached' from the database
$getLinkQuery = mysql_query("SELECT link,author FROM lotd WHERE id = ".$number_reached) or   
       die (mysql_error());
$row = mysql_fetch_row($getLinkQuery);

// print link $row[0] and author $row[0]
echo $row[0]." - " . $row[1];

modified from http://www.hotscripts.com/cgi-bin/dload.cgi?ID=14287

[Weedpacket]

Change this line

mt_srand((double)microtime()*1000000);  

To use something based on the date instead of (double)microtime()*1000000. date('Ymd'), perhaps?

Gee, that was easy.