i have simple query displays random results, i'd able keep same results 24 hour period per visitor doesn't randomize on every page refresh. here's query:
<?php $rs1= mysql_query(" select * table_1 order rand() limit 4 "); while ($row1= mysql_fetch_array($rs1)) { ?> i gather i'll need use date somehow. did figure out how random number show 24 hours:
<?php date_default_timezone_set('america/los_angeles'); mt_srand(date('ymd')); $number = mt_rand(50, 5000); mt_srand(); //reset other calls echo $number; ?> but i'm not sure how make work original query. ideas? or should creating cookie rather trying php? how make cookie work it?
this bit cpu intensive if have calculate on lot of rows, not uses cookies nor special data keep selection.
select * table order md5(concat(id,curdate())) limit 4 will show same order on every query on same day. if want diferent based on user doing query still same on day, can add id concat too.
select * table order md5(concat(id,userid,curdate())) limit 4 should say, results no more random , can predicted takes job. can add seed too, mitigate way effect.
