Events equivalent for MySql 4.1.xxx

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
gim.daniel
Forum Newbie
Posts: 2
Joined: Mon Jul 03, 2006 6:52 am

Events equivalent for MySql 4.1.xxx

Post 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
Post Reply