Re: Joke of the day problem

On Mar 8, 2007, at 5:30 AM, Delta Storm wrote:

Hi, again me with the silly questions... I need a script that will take data from MySQL database and display one row each day. I have googled, but with no luck. The database retrieving mechanism is of course clear but I really dont know how to do a 24h delay before the next row is displayed. Thanks in advance :)

I would write the query results to a php file as string variables and when someone requests the page have a date conditional to decide which string to display. Or if you want to pull a joke from the database one at a time just use date to determine which one. For this you may have to have a persistent php file to include to keep track. Ideas; maybe one looks good? Best Jeff k