Or make a 'truncate.sql' file with the tables in it to truncate: TRUNCATE TABLE foo; TRUNCATE TABLE bar;
Then in the crontab "mysql mydatabase < truncate.sql" No PHP needed. > -----Original Message----- > From: Daniel Brown [mailto:[EMAIL PROTECTED] > Sent: Friday, February 22, 2008 6:59 AM > To: Zoran Bogdanov > Cc: php-general@lists.php.net > Subject: Re: [PHP] Deleting all rows in a database every 24 hours? > > On Fri, Feb 22, 2008 at 1:28 AM, Zoran Bogdanov > <[EMAIL PROTECTED]> wrote: > > The title says it all, how do I perform an action every 24 hours? > > Another question better answered on Google. > > PHP Script: > <? > $sql = "TRUNCATE TABLE `tablename`"; > mysql_query($sql); > ?> > > Crontab Entry: > 40 3 * * * `which php` /path/to/your/script.php > > That will run every morning at 3:40a server time with the > path-preferred PHP. If you're on Windows, look up Scheduled Tasks. > > -- > </Dan> > > Daniel P. Brown > Senior Unix Geek > <? while(1) { $me = $mind--; sleep(86400); } ?> > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
