View Single Post
Old 06-27-2007   #4 (permalink)
basicwe
Steven
 
Join Date: Jun 2005
Location: McAlester, OKlahaoma - United States
Posts: 21

Sequential.

Quote:
Originally Posted by notjustgraphics View Post
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.

It could be sequential it wouldn't be a big deal to just let it be some sort of loop.

It's not pulling the info out of the database, or the order that is important to me. It's finding a way to display the info for one full day.
basicwe is offline