Hi Eric
This is what we've got:
1. On the products page you click on a Type which takes you to the Makes page, url looks like: Makes.php?ItemTypeID=1
On the Producutspage no variables or GET in the Recordset (sql)
2. Then on the Makes page you click on a Make to go to the Styles page, url looks like: Styles.php?ItemMakeID=1
On the Makes page the Recordset (sql) looks like:
SELECT Items.*, ItemMake.*, ItemStyle.*, ItemType.*
FROM Items INNER JOIN ItemMake ON Items.MakeID = ItemMake.ItemMakeID INNER JOIN ItemStyle ON Items.StyleID = ItemStyle.ItemStyleID INNER JOIN ItemType ON Items.TypeID = ItemType.ItemTypeID
WHERE ItemTypeID = colname
Variables, Name: colname
Type: integer
Default value: -1
Runtime value: $_GET['ItemTypeID']
3. Finally on the Style page you choose a Style to go to the Details page, url looks like: Detail.php?ItemStyleID=1
On the Style page the sql looks like:
SELECT Items.*, ItemMake.*, ItemStyle.*, ItemType.*
FROM Items
INNER JOIN ItemMake ON Items.MakeID = ItemMake.ItemMakeID
INNER JOIN ItemStyle ON Items.StyleID = ItemStyle.ItemStyleID
INNER JOIN ItemType ON Items.TypeID = ItemType.ItemTypeID
WHERE ItemStyleID = colname
Variable, Name: colname
Type: integer
Default value: -1
Runtime value: $_GET['ItemMakeID']
4. The Recordset on the final Details page looks like:
SELECT Items.*, ItemMake.*, ItemStyle.*, ItemType.*
FROM Items INNER JOIN ItemMake ON Items.MakeID = ItemMake.ItemMakeID
INNER JOIN ItemStyle ON Items.StyleID = ItemStyle.ItemStyleID
INNER JOIN ItemType ON Items.TypeID = ItemType.ItemTypeID
WHERE ItemStyleID = colname
Variables, Name: colname
Type: integer
Default value: -1
Runtime value: $_GET['ItemStyleID']
Hope that helps.
