Đang Thực Hiện

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', [url removed, login to view], 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 thêm: 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, 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, php photo block

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

Mã Dự Án: #1877252

Đã trao cho:

dwa

Hi. Please find the demo link in pmb.

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