Simple MySql Query Script Needed

Avg Bid (USD)
Project Budget (USD)
$30 - $250

Project Description:
Here’s what we need built:

I need a MySql query script witten that will do the following:

1- Query a Magento database every night and write the information to 2 tab delimited text files (one of the text files needs 16 fields queried, the other 2 fields).
2- Email these files to an email address.

The information is information related to Magento orders that were processed in the last 24 hours.

Please see the attached text file that is formatted the way that I need it, only the fileds with MANDATORY in them need to be filled in, just leave the others blank.

IMPORTANT NOTE: The headers in the test files are the SQL Field names in the Magento MySql database, the header information IS NOT necessary in the final product.

When completed, it will work like this:

The script is setup on a chron job, every night (once every 24 hours) the script will execute and create the new files, it will then email the results to an email address.

I need this setup and turned around quickly and will give a bonus for it being done early.

Please, do not bid if you cannot meet the deadlines, I'm sorry for the quick turnaround but this is urgent.

Ultimately we are looking for professionals that we can work with in the future, please keep this in mind.


If you can turn this around in less than 2 days I will pay a generous bonus!

Skills required:
Magento, MySQL, PHP, SQL
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.