SELECT a.name, a.nameid, a.required FROM OptionName a INNER JOIN OptionValue b ON (a.nameID = b.nameID and a.productid = b.productid) WHERE a.productid = #productID# GROUP BY a.name, a.nameid, a.required SELECT * FROM OptionValue WHERE nameID = #nameID# and Active = 1 ORDER BY valueid, value_desc

In Stock:	#QtyInStock#
Qty:
#name#:

Out of stock. Click here to special order this item.