My thought process (besides being fried) is this.
I have the recordset, itemscat3, to loop through filtered by itemcatID (category 3)
the repeat region loops the items recordset
create the recordset, colors, to show the items color options (not sure if my sql is correct) this is the sql (SELECT *
FROM items, colors, color_lookup
WHERE color_lookup.item_colorID = myfakevar) runtime value of myfakevar is $_POST['myfakevar']
(here i am fuzzy) i dynamically populate the select list with the colors recordset with label and value as colors
end the loop is at the bottom of the page
i moved what i think is the recordset, colors, inside the recordset (after the PHP do code)
as far as the myfake variable, my thinking is i am telling what the variable should be with the code
<?php
$_POST['myfakevar'] = $row_rs_itemscat3['item_colorID'];
?>
so in effect the sql filtering the recordset, colors, now says that color_lookup.item_colorID is equal to items.item_colorID which should filter the options of colors by the record of items.
