Đã hoàn thành

131084 MySQL DB output help

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/[url removed, login to view]'

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'

Kĩ năng: Bất kì công việc gì, MySQL, PHP

Xem nhiều hơn: mysql db, block agency, race parts, kevin, jail, fd, bond, php show information mysql, mysql help table, mysql output table, release block, mysql show date, php mysql show table columns, output using, output table, order mysql, mysql output, php mysql block, output data mysql, php mysql block time, mysql php output, date agency, weight date php, count mysql, photo agency

Về Bên Thuê:
( 6 nhận xét )

ID dự án: #1877252

Được trao cho:


Hi. Please find the demo link in pmb.

$50 USD trong 1 ngày
(196 Đánh Giá)