View Full Version : Post 1 item from sql database for 24 hrs

10-04-2002, 04:04 PM
I run a internet shopping codes website and need to post 1 deal from the database table each day for 24 hours. how can I do this?

Any help much appreciated!

10-04-2002, 04:11 PM
Are you wanting this to happen automatically without you having to manually do it everytime?

10-04-2002, 04:15 PM
Yes, I want the "Deal of the Day" to change every 24 hours.

10-04-2002, 10:21 PM
You can do this using a CRON job that is set up to execute a SQL file with the query that you need to perfom. The CRON job can be set to run every 24 hours.