Find Jobs
Hire Freelancers

131084 MySQL DB output help

N/A

Completed
Posted about 17 years ago

N/A

Paid on delivery
I have a table (see attached file) where several parts of the information is duplicated. I need to format the output using PHP and MySQL so the duplicated data like `booking_number`, `date`, `time`, `last_name`, `first_name`, `middle_name`, `dob`, `race`, `sex`, `height`, `weight, `block`, `photo` only show once for each unique `booking_number` but the remaining columns `count`, `charge`, `bond`, `cause`, `ic`, `court`, `other`, `release`, `agency` show all the data across several `booking_numbers`. ie. for `booking_number` '200700001607' I should see '200700001607', '2007-04-10', 173931, 'ADDINGTON', 'TIMOTHY', 'KEVIN', '1961-07-12', ' W', ' M', 5.11, 235, 'I307 - BED', '200704/[login to view URL]' then see the following for charge 1: 1, 'RETURN TO COUNTY JAIL PER COURT ORDER', '0', '48C01-0610-FC-00407', 'MADCO1.5', '48C01', 'C010610FC00407', '0000-00-00 00:00:00', 'MCPD' then for charge 2: 2, 'RETURN TO COUNTY JAIL PER COURT ORDER', '0', '48C01-0611-FD-00429', 'MADCO1.5', '48C01', 'C010611FD00429', '0000-00-00 00:00:00', 'MCPD'
Project ID: 1877252

About the project

1 proposal
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi. Please find the demo link in pmb.
$50 USD in 1 day
5.0 (196 reviews)
6.8
6.8

About the client

Flag of
5.0
6
Member since Mar 14, 2004

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.