Ok i need to execute an sql query at a certain time of day and they only way i think this can be achieved is through a cron. The only problem is that i haven't a clue how to do it.

Code:


thats the SQL code but i need that executed at a certain time on a certain database every day. can anyone help me as i have know knowledge of cron what so ever - have a fealing i need to do that database bit in php but im not sure what code to put in as it will interact with cron.
Help...

I am assuming your not using cpanel, if you are you could set them up that way. any ways I thought I toss this little code up for you

http://www.sitepoint.com/article/introducing-cron

it's a series of php scripts and some mysql that should get it going for you.

well i am using cpanel. cpanel cant execute sql queries from cron so id need a php script that had all the data in it then set cron to run the php script at a certain time of day

Yup. You need to get the cron job to run the PHP

I use something like this.


(If you set up the cron job under the Unix style interface, you will see that there are boxs for the 0s and *s, and then one big text input for this:



This is the path to PHP.


Quite. The > /dev/null might make it so you don't need this.


The path from your top directory to the PHP file


I think this makes it so that the output is deposed of. Not sure though.



Inclding something like this:


At the top of the script would, I think, make it so the script can't be run from your browser, it has to be run via the cron job.


Hopefully this will have helped. I don't know very much at all on this subject.

This post has been edited by Yacoby: Jan 12 2007, 07:41 PM

Thanks got it working

Mod close topic