Step 1 and 2
Hi Jason,
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:
SELECT
ps3_categories.CategoryName,
ps3_categories.CategoryID,
ps3_products.ProductName,
ps3_productcategories.ProductID
FROM
ps3_categories
Inner Join ps3_productcategories ON ps3_categories.CategoryID = ps3_productcategories.CategoryID
Inner Join ps3_products ON ps3_productcategories.ProductID = ps3_products.ProductID
ORDER BY
ps3_products.ProductID ASC,
ps3_categories.CategoryName DESC
Current questions:
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...