Completed

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
Project Budget
$30 - $250 USD
Completed In
1 day
Total Bids
12
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