XML Help

[BulldogGC]

Okay, this is what I want to do --

I want to output the last 10 headlines from a MySQL DB into a static XML file.
And I only want that XML file to be updated every 5 hours from the database.
How would I go about doing this?

[FrozNic]

what os is your server running? u can use a cron job on *nix and use the task manager in windows to setup 'jobs' to run at certain times or every so many mins. then use php to create xml pages on the fly, or better yet, post them in a dbase and have them as an include in your page somewhere...

[stolzyboy]

and...i believe that the only way you can use the task scheduler on win is if you have the cgi version of apache, not the apache module, since you can't just run a php page or something like that, you would need to call a command via command line with the task scheduler

and yes you can use cron on nix, with either wget or lynx to run a php page, simply use google to search run php page with cron and you will see many tuts out there

[FrozNic]

oops, task scheduler .. 🙂