Execute SQL statements w/ php every 3 days?

SQL statement, execute SQL, php, MySQL

[JayDev]

Does anyone know how to write some php code to run a couple SQL queries on the database once every 3 days for example?

Any help would be great!

I guess it would involve the use of the date function(s).

Thanks,
JayDev

[TomAnthony]

WIth your hosting setup, do you have the ability setup cron jobs? These are just scheduled events on the server that do certain things, which could be to run your PHP.

Otherise, I think some trickery will be needed to somehow fire that PHP code.

[JayDev]

It seems that I have pretty flexible access to my server even though it is hosted by 3rd party.

Do you know where I should look at in cpanel to create cron jobs?

Do you know a good source of info for cron jobs?

Thanks,

[apetit]

Its on the cpanel main page - Cron jobs
A fair way down
I see it at
http://example.com:2082/frontend/x2/cron/index.html
Your use of theme may change that

[edited by: coopster at 12:50 am (utc) on Feb. 19, 2007]
[edit reason] generalized domain [/edit]