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.


