grouping data ... - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

pepe_lepew1962 · 01-04-2011, 11:24 PM

Hello, I am having problems with displaying grouped records from mysql and could desperately use help. In the example below, I want to display the Order Number ONCE and ALL the records associated with that order. Then carry on to the next record and so on. Here is a sample of what the output is suppose to be. Can anyone help me with this. The key being to not display the Order Number on every line.

tblName1.OrderNumber tblName2.Name tblName2.Price

12653 PBXL 396.52
ABCD 426.28
GEDL 385.20

12654 ABCD 515.18
FGHL 520.00

12659 PBXL 612.35
FGHL 619.20
XTRL 420.39

Thanks.