Can Someone Help Me With A Cronjob?

[sgoodwin]

I wonder if someone might be able to help me with this (or maybe just tell me if I'm better off hiring someone to do it for me, if it's too involved for this forum):

 

I need a cronjob to run each weekday at a particular time in the afternoon. I want it to go get the contents of certain fields in a table in one of my databases, export the contents to an excel file, and e-mail it to a couple of people. After it's mailed the records each day, I want it to start over and mail the new day's records the following day.

 

Thanks in advance for any advice you might give me.

[TCH-Bruce]

First you need to write the script to get the data and convert it to a spreadsheet. Then you can add a routine to email the created spreadsheet. Once you have that, it is simple to create a cron job to run it.

[sgoodwin]

First you need to write the script to get the data and convert it to a spreadsheet. Then you can add a routine to email the created spreadsheet. Once you have that, it is simple to create a cron job to run it.

 

alright, so I'll hire someone to write the script... in what language would you say? PHP? Thanks!

[TCH-Bruce]

PHP would probably be best.

[TCH-Andy]

yes, PHP should be fine.