On Tue, Jun 05, 2001 at 11:27:33PM +0500, Hasan Niyaz wrote:
> Hi,
>
> I have a room inventory. Clients can block rooms them but I want to
> release them after a specified time if they do not release them
> normally via the given link. I want to be able to trigger an event
> to release the rooms after the time limit. Is there any way I can
> do this with MySQL or PHP.
You'll need to use a batch scheduler like cron (on Unix/Linux) to run
a script that does it (or fetch a URL which runs a script that does
it).
MySQL doesn't have scheduling capabilities built into it (and probably
doesn't need them), so simply need to use a tool that does.
Jeremy
--
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 11 days, processed 68,753,894 queries (71/sec. avg)
