Hey,
I have a row in a sql table, and I want to know how I can empty it or set all of them back to zero.
IE
UPDATE `users` SET `reptime` = 0 WHERE `id` = *
(not sure if that's 100% right, the last part)
but how would I do it with a cron job?
Cheers!
Printable View
Hey,
I have a row in a sql table, and I want to know how I can empty it or set all of them back to zero.
IE
UPDATE `users` SET `reptime` = 0 WHERE `id` = *
(not sure if that's 100% right, the last part)
but how would I do it with a cron job?
Cheers!
UMMM.
I think theres a way to do it if you put the command in the file and get the cron job to run the file..
But i have no idea how.
EDIT:
Put it in a file, then do the cron command
php -f /home/YOUR ACCOUNT USERNAME/public_html/PATH TO FILE
I'm adding info! Plus can't edit.
That didn't work. :(
I have the file named cron1.php, with the code in it. So when I visit the page it executs it. I now understand the cron command needs to be something where a browser on the server visits this page. What would be the commad for that?