View Single Post
Old 06-26-2007   #3 (permalink)
notjustgraphics
Rusty Bio-Hazard!
 
notjustgraphics's Avatar
 
Join Date: Sep 2006
Location: Toronto, Ontario, Canada
Posts: 1,162

Send a message via MSN to notjustgraphics
Jolt's method will work, but it may create some unnecessary MySQL Queries...

There may be a way to select a record based on the Current Date...

Since Dates are expressed in a Julian method, no second ever has the same time stamp... if you keyed based on the date itself, there would be an automatic 24 hour period... when the next day starts, it will show the next record...

Is there a reason that your selection of records has to be randome? Can it not be sequential?

Just curious..

Mike.
__________________
notjustgraphics is offline