[RESOLVED] Random data every 24 hours

[jansky]

to all guru

Is there a possible way to random data every 24 hours? My table has a date field but it has nothing to do with the random sequence.

we can random data like : select * from yourtable order by rand() . but this always perform everytime we refresh the page

Thanks

[Roger_Ramjet]

2 tables and a cron job will do this nicely

Main table holds base data, work table hold the randomised data for use today, cron job reloads work table every 24 hours

additional index column recreated with new random order every 24 hours would do the same

both solutions would need to handle inserts in some way.