How do you automatically clear a table?

No, Simon just e-bullies me. :'(

PHP Code:

---

$time = date("H:i");
if($time == "00:00"){
$query = mysql_query("TRUNCATE TABLE `table_name` ;");
} 


---

May've got that wrong.

<?php
include "config.php"; // config file

$query = mysql_query("TRUNCATE TABLE `table_name` ;");

?>

go into cPanel.
Go to cron jobs, put the command as:
wget http://www.site.com/myfile.php

Then set the time to everyday at 00:00 of every week of every month of every year.

Quote:

---

Originally Posted by Dentafrice,

<?php
include "config.php"; // config file

$query = mysql_query("TRUNCATE TABLE `table_name` ;");

?>

go into cPanel.
Go to cron jobs, put the command as:
wget http://www.site.com/myfile.php

Then set the time to everyday at 00:00 of every week of every month of every year.

---

Humm, how do you do it so it deletes say:
the data in 00:00 etc..?

you set the cron to run the file at the time you want it delete and also

Simon why are u so up your self?
Just because someone else helped more then you.

Quote:

---

Originally Posted by Mattx.org

you set the cron to run the file at the time you want it delete and also

Simon why are u so up your self?
Just because someone else helped more then you.

---

:| there is no need to be so rude.

Yeah, just ignore me. ('ere.)

I made it so that it deletes them, but also re adds them at the same time :)

Re-adds the table structure? That's exactly what TRUNCATE does, anyway :P