I'm trying to write a php page that displays data from a JOIN query for a specific ID
table view
brandinfo
ID, brand, discounttype
1, antioni, no discount
brandproducts
brandID, producttype, price
1, Tshirt, 20.00
1, Pants, 30.00
1, Shoe, 40.00
the returned result is
1 antioni, no discount, Tshirt, 20.00,
2 antioni, no discount, Pants, 30.00
3 antioni, no discount, Shoe 40.00
The way I want the page to be displayed is
------------------
Antioni (at the top)
Table
1. Tshirt 20.00
2. Pants 30.00
3. Shoe 40.00
no discount (at the bottom)
----------------------------
How should I construct the PHP page from the result since they're retrieved as rows?