Hi good idea to implement, for this option you choose 2 option. 1. mysql trigger/stored procedure 2. Cron job if you using mysql 5.x then use Stored procedure (its interesting and easy way) otherwise set the cron tab php file to update the records. Thanks Muthukumar Selvarasu, Project Manager (Web Development), Webmaster Ltd. _____ From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of sandesh.s_magdum Sent: Thursday, December 06, 2007 8:00 PM To: php-objects@xxxxxxxxxxxxxxx Subject: How to update a mysql table after certain hours? I need to set say `status` field of a mysql table to 'N' for suppose 8 hours. After completing 8 hours the `status` should be set to 'Y' again. Is there any technique like mysql triggers or mysql events with which I can achieve my requirement? Thank you in advance! Have a great day ahead. Regards Sandesh. [Non-text portions of this message have been removed]
