Simple MySql Query Script Needed

In Progress

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.

THIS PROJECT MUST BE COMPLETED IN 2 DAYS MAXIMUM!

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

Skills: Magento, MySQL, PHP, SQL

See more: mysql query magento, mysql query script, sql less than, write query, write a simple php script, urgent mysql, sql work needed, simple query, need a quick mysql script, mysql test, mysql query, php script execute, sql final, tab delimited text, php tab php mysql, write simple php database, last days sql, magento query, sql create script, blank fields, write test script, write script file, write mysql, php header script, query email

Project ID: #1554525