Re: Deleting all rows in a database every 24 hours?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Feb 22, 2008 at 1:28 AM, Zoran Bogdanov <test1.test1@xxxxxxxxxxx> 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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux