S
savvy
I am developing a Garments shopping cart. On the single product page
where the customer selects size and colour of a garment and if its ok
for him, then adds to his basket, so every time he checks for Colour
(dropdownlist) and Size (dropdownlist) I'm checking whether the Item is
"In Stock" or "Out of Stock" and displaying the same using a Label
outside.
Is their any way so that I can display "In Stock" or "Out of Stock"
inside the dropdownlist menu of the Size when the customer chooses a
Colour. The pattern wanted is displayed below.
Colour DropdownList
Black
Blue
Green
Size DropdownList
3 yrs (In Stock)
6 yrs (Out of Stock)
12 yrs (In Stock)
I have no idea how to add an extra field inside the DropdownList.
Any ideas would be of great help to me and will be greatly appreciated
Thanks in Advance for your time
Database Queries:
SELECT * FROM ProductClrIcons WHERE ProductID=@prod_id -- (For
ColourIcons)
SELECT * FROM ProductSizes WHERE ProductID=@prod_id--- (For Sizes)
SELECT * FROM ProductSizesColours WHERE ColourName=@colname AND
Sizes=@sizes AND ProductID=@prod_id--- ( For StockLevels)
where the customer selects size and colour of a garment and if its ok
for him, then adds to his basket, so every time he checks for Colour
(dropdownlist) and Size (dropdownlist) I'm checking whether the Item is
"In Stock" or "Out of Stock" and displaying the same using a Label
outside.
Is their any way so that I can display "In Stock" or "Out of Stock"
inside the dropdownlist menu of the Size when the customer chooses a
Colour. The pattern wanted is displayed below.
Colour DropdownList
Black
Blue
Green
Size DropdownList
3 yrs (In Stock)
6 yrs (Out of Stock)
12 yrs (In Stock)
I have no idea how to add an extra field inside the DropdownList.
Any ideas would be of great help to me and will be greatly appreciated
Thanks in Advance for your time
Database Queries:
SELECT * FROM ProductClrIcons WHERE ProductID=@prod_id -- (For
ColourIcons)
SELECT * FROM ProductSizes WHERE ProductID=@prod_id--- (For Sizes)
SELECT * FROM ProductSizesColours WHERE ColourName=@colname AND
Sizes=@sizes AND ProductID=@prod_id--- ( For StockLevels)