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
Employer working
Completed by:
Skills Required
Project Budget
$30 - $250 USD
Completed In
1 day
Total Bids
Project Description

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]

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online