UPDATE SCRIPT?

[codrgii]

I'm looking to update a sql table using php, i wish for a php script to update and insert the time it was last ran so it inserts that time into a sql table, which php function is best suited for the job and would you mind showing an example of it?

[Wolphie]

Put this at the top of your update script:

 

<?php
mysql_query(sprintf("UPDATE sometable SET column1 = %d", time()));
?>

 

Every time the update script is ran, it'll update a specific column in a specific table with the current time the script was ran.