How to make a mysql query auto-run every week?

Hi DPers, I would like to know how in PHP is possible to make something autorun every n time (everyday/every 7 days for example).

What I have to do is to run this mysql query every 7 days:

UPDATE table SET published=1 WHERE date <= CURDATE()

Code (markup):

so I can upload many files to the server in advanced and show it (publish) only when the date in the table is equal to today date.

Please give me detailled instructions as I'm not an expert. I think this is not so difficult.

Thanks

 

you can use cron to run it

 

Here follow these steps:
Go to your hosting Cpanel
There you will find something like Cron Jobs or Cron, select that
There it will ask for the time interval and location of the php file, give the required data.
Thats all!

 

I had used Cron Jobs in the past with another script but it wasn't working (probably due to a problem in the script file)

Meanwhile I try with this file, is there an alternative method without Cron Jobs?

 

Is there a page on your site that is always accessed by a site visitor at least once a day but must be everyday?

 

The homepage is visited everyday, but I thought there was a function to make it to set it to run every "n" time.

 

I can make a program which opens the page when your computer is on. You can set it to do at a particular time by using schedule task.

 

you can write triggers

please look at

hxxp://dev.mysql.com/doc/refman/5.0/en/triggers.html