RE: Scheduling with MySQL

2002-04-27 Thread Ben Holness
> However, I would suggest, if you have control of the search > tools, that you simply put in an extra timestamp field called > "hideuntil" into your database, and add conditions into your > searches that drop rows for which hideuntil is not null and is > after the current time. This is a great i

Re: Scheduling with MySQL

2002-04-26 Thread William R. Mussatto
IL PROTECTED] > Subject: Re: Scheduling with MySQL > > > I do not think MySQL has any scheduling abilities, clever or > otherwise. MySQL just obeys orders. Scheduling (correctly, in > my opinion) is the province of cron and suchlike. > > However, I would suggest, if you have

Re: Scheduling with MySQL

2002-04-26 Thread Alec . Cawley
I do not think MySQL has any scheduling abilities, clever or otherwise. MySQL just obeys orders. Scheduling (correctly, in my opinion) is the province of cron and suchlike. However, I would suggest, if you have control of the search tools, that you simply put in an extra timestamp field called "

Scheduling with MySQL

2002-04-26 Thread Ben Holness
Hi all, I have a PHP based web interface that interacts with MySQL to let users insert data into a table called "Messages". Once an entry is made in this table, other applications read and process the entries, modifying them where appropriate. I would like to add the capability to have this inse