Page 1 of 1

Events equivalent for MySql 4.1.xxx

Posted: Mon Jul 03, 2006 6:56 am
by gim.daniel
Is it possible to modify an entry in a database for a specific time and then if an event doesn't occur after that time ahs exceeded, to automatically put it back to the original value?

It might help if I explain my problem

I am a hotel and i am writing my own booking system.

I want guests to specify when they want to come to the hotel and at that moment i want to "hold" the room until they make payment. If they don't make the payment i want to "release" the room again.

Any advice and suggestions would be great.

i am writing it in PHP and I have a mysql 4.1 database.

Using mysql 5 event would be ideal - so is there a work around for the event keyword in mysql 4.1