Using PHP My Admin to set up a database that updates weekly? How?

I have set up a static database, but I need it to update it weekly...

[zander213]

Greetings all,

I am trying to learn how to create a database that is updated on a weekly basis from an HTTP datafeed. The link changes weekly (see sample below...notice the date at the end). I think a CRON task would be the best way (am I right?), but I have never written a CRON task.

Can anyone help with this?

[edited by: jatar_k at 9:00 pm (utc) on Jan. 24, 2005]
[edit reason] removed personal info [/edit]

[dreamcatcher]

Do you use cpanel? To set a cron job in cpanel, try their help forums, they have several threads on cron jobs there.

The command you need is:

php -q /home/server/path/files/file.php

Use your server path with a gap before AND after -q to run the file you want. You`ll need to set an e-mail to send the output too, so keep the output minimal if you don`t have much storage space. Otherwise, you`ll have to keep deleting e-mails on a regular basis.

Hope that helps.