[SOLVED] Wanting to automate a sql statement

[Voodoo Jai]

I have a table in a db that I want to delete the contents, re initialise the auto-increment and start inputting new data again at a particular time every day.

 

Could someone point me in the right direction as to how this can be done if at all.

 

VoodooJai

[fenway]

You should be able to run TRUNCATE on a cron -- or use the 5.1 event scheudler.

[Voodoo Jai]

Could you give me some more details as I cannt find details in google with cron as the search term.

[fenway]

Could you give me some more details as I cannt find details in google with cron as the search term.

That's impossible.

[Voodoo Jai]

Fter many hours of searching I found this section of code:

 

<?php
MYSQL_CONNECT('localhost','database_username','database_password');
@mysql_select_db("database_name") or die(mysql_error());

$query="TRUNCATE xoops_session";
$query="ALTER TABLE table-name AUTO_INCREMENT =1";

mysql_query($query);
mysql_close()
?> 

 

I want to specify a specific table within a db, so do I need to change

 

TRUNCATE xoops_session

into

 

TRUNCATE db-table-name

 

then how do I get it to run at a specific time of the day and

[fenway]

You don't need to run the alter statement, truncate does that automatically.

[Voodoo Jai]

Thats great thank you, I found a good explanation from this web site.

 

http://www.thesitewizard.com/general/set-cron-job.shtml

 

Most helpful as well as PHPFreaks