Re: Emptying mySQl database on time-based factor!!!
| From: | Thomas Edison Jr. | Date: | Sat, 25 Nov 2000 12:06:00 +0000 |
| Subject: | Re: Emptying mySQl database on time-based factor!!! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-27131@lists.php.net to get a copy of this message | ||
I guess "Popular Opinion" says i should use the
crontab method for my job....then i guess i'll go for
that....
Just tell me where i can get to read up on the cron/
crontab thing? How i can actually use this scriptwise
for my job.....
Thanks a lot guys,
Regards,
T. Edison jr.
> You could write a crontab PHP script to do it.
> Add a timestamp column to each table, and simple
> have a series of:
> $query = "delete from blah where update + '@ 2
> hours' <= now() and name =
> 'criteria'";
> mysql_query($query);
=====
Rahul S. Johari (Director)
******************************************
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : abraxastech@yahoo.com
Tel : 91-4546512/4522124
*******************************************
__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/