Post 1 item from sql database for 24 hrs

[savingc]

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!

[Spookster]

Are you wanting this to happen automatically without you having to manually do it everytime?

[savingc]

Yes, I want the "Deal of the Day" to change every 24 hours.

[Spookster]

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.