RE: [PHP-DB] MySQL, PHPand cron

2002-03-28 Thread Gurhan Ozen
Hi Jenn, There are a couple ways you can do this. You can write a unix shell script and run it periodically at the cron. Here: #!/bin/mysql query="DELETE FROM tablename" /usr/bin/mysql -u USER -pPASSWORD -D database -e "$query" And then you can just put this script into cron, see: http://www

RE: [PHP-DB] MySQL, PHPand cron

2002-03-28 Thread Jonathan Hilgeman
First create the PHP script to connect to the database and empty the table ("DELETE FROM table;") as if you were going to visit the page manually every time you wanted to empty the table. This shouldn't be too hard: Once you have that working (test it by visiting the page and then checking to s