Step 1 and 2
I took your example and made a recordset and tried it in a phpmyadmin sql call and in each case I got a #1064 error about "the syntax to use near ['ProductID'] at line 1".
Here's the SQL I came up with:
Inner Join ps3_productcategories ON ps3_categories.CategoryID = ps3_productcategories.CategoryID
Inner Join ps3_products ON ps3_productcategories.ProductID = ps3_products.ProductID
1. My problem is connecting this to the current row being displayed? I keep getting syntax errors trying to connect it to the $row_WADAProducts[ProductsID]
2. I'll admit I'm not good with the grouping and do/while code. I hope I have explained enough for someone to help me with this. THANKS again in advance...