The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I have a PHP script that is designed to retrieve a comma delimited CSV file from 4 different affiliate accounts, then insert the data into specific MySQL database tables.
What I need:
1. One of the CSVs no longer gets inserted into the database correctly, I believe the structure of it has changed and currently, nothing gets inserted at all. I need my PHP script fixed so it will insert the CSV data as required.
2. The PHP script requests a CSV file for the entire current month's data of each affiliate account each day, it then truncates the specified tables and inserts the new data.
I need the script modified to create month-specific tables on the 1st of each month, eg. table names: 2009_January, 2009_February, 2009_March, etc. and also retrieve the previous month's data and update the previous month's table. (as final stats are often delayed by 24 hours).
This will allow me to store and retrieve data for any specific month.
I will provide:
The PHP script I use to retrieve and ...
Sign in or Register to see more