How to schedule data extractions based on requirements

[liveshotz]

Hello,

I'd like to SCHEDULE a task to run automatically once per week that would EXTRACT all records from PHPBB_USERS which have either been newly created that week or were edited by the client within the same period.

The data would extract to a COMMA-DELIMITED file which would then be automatically emailed using the PHP mail command to an intended recipient so that she can MERGE the datafeed into a larger and more complex offline database.

Not entirely sure how this would be done, but I'm sure CRON would somehow get involved with the task.

Any ideas or help would be greatly appreciated.

Thanks!

PS: my configs:>> RedHat Linux / Apache / PHP / MySQL

[Scrowler]

do you physically own your server? im not sure but i think youd have to setup a physical program on the server not just a web script if you wanted to do that..