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: CODE UPDATE trap17_ipbmembers SET points = points - 1 WHERE mgroup = 3 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...

Reply

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.

Reply

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

Reply

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.

 

 

 

Reply

Thanks got it working

Mod close topic

Reply