Hi, Going back to this. The method I posted below works great, my only problem is that within my database I have each item in inventory listed separately with a separate ID. In other words if I have a shirt that has 3 different sizes, I have 3 different lines with 3 different ID #s within my database:
itemId: 102 itemName: White Polo itemSize: M
itemId: 103 itemName: White Polo itemSize: L
itemId: 104 itemName: White Polo itemSize: XL
Within e-Cart how would I call out the correct item ID#?
I am currently building two recordsets within Dreamweaver as follows:
rsWhiteShirt
SELECT *
FROM inventory
WHERE itemId = 102
rsShirtWhite
SELECT itemId
FROM inventory
WHERE itemName = queryparam1 AND itemSize = queryparam2
queryparam1
type: text
default value: ""
runtime value: $_POST['itemName_1']
queryparam2
type:text
default value: ""
runtime value: $_POST['sumidrive1_1_Size_Add']
These recordsets seem to work when there is a different price dependent upon what size the user selects. I bind the price to the rsShirtWhite (the second recordset) and it populates the shopping cart with the correct price. However, how do I get the correct ID to populate in the shopping cart? If I bind the ID column to the second recordset's ID column, should that not populate the correct ID according to size? Why would this method work for the price and not the size?
Any input you could give me would be greatly appreciated!
Thanks!