MySQL export to csv for multiple rows with same id
This project was successfully completed by lfr2 for $35 USD in a day.Get free quotes for a project like this
Project Budget$30 - $250 USD
Completed In1 day
We have a Wordpress site with custom wp_usermeta data that relate to user accounts. Through Wordpress we can view the data as it should look - rows of unique data with the columns containing each value. We need a basic php script that we can upload to the server and execute (just needs to be a single file with no interface). so that a csv is downloaded. This information needs to be joined with the related user in the wp_users table.
E.g our wp_usermeta looks like this:
umeta_id user_id meta_key meta_value
1 1 first_name joe
2 1 last_name blogs
3 1 number 33333
4 1 street henry
5 1 nickname jimmy
6 1 favcolor blue
7 1 town brisbane
8 2 first_name jim
9 2 last_name doe
10 2 number 5667
12 2 street birker
13 2 nickname jack
Note, there are approx 18 different meta_value entries for each user and sometimes there is not a value entered. When there is no value it needs to display a blnk in the csv so the columns are retained.
Please only bid if you can do this today.
This link shows the exact code we need: [url removed, login to view]
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online