product option problems
I am trying to put in product options. I have a table, "options" that lists all the options for every product. The options are identified by a group id # 1,2,3, etc. I am working on a category page and want the options to be shown here. Not every product on the page has options and there are different options for different products. When I do a recordset, "rsfoptions", it returns all of the options. When I look at the page in my browser every product has every option. I need help with the codinging . Ecart is not too user friendly on these things. I have pasted the recordset code below.
SELECT *
FROM options INNER JOIN items on items.optid=options.optgrpid
WHERE itemid=param
name=param
type=numeric
default value= 0
runtime value=$run_rsfrozen['itemid']
"itemid" is the pk column in the items (or product table). This table has a column identifing the option group id.
Any advice would be greatly appreciated.