inventory in detail pages
Some of my products have sizes (rings). I have my products table with descriptions etc, then I have my inventory table. There the columns are inventoryid, prodid, size and quantity. If a product has a size it is registered in inventory with its product id and an inventoryid is automatically assigned to it. It it has more than one size, a new inventoryid is assigned and its prodid from products remains the same. The store owner puts the info for size and quantity in the table for a product, and the inventoryid is assigned and the prodid is brought over automatically. If I have a product with sizes I have a size rs on the detail page, so the customer can pick a size. The size recordset is from the inventory table. If no size there is no rsSize. I have included a detail page for sizes(detail_signature.php, also not all in the signature collection have sizes so I have a showif statement ) and a detail page where no sizes exist. So my question is how do I filter the rs for detail pages that have the size rs and do not.