sabret00the
07-15-2005, 04:17 PM
ok i have a table called sections, another called categories and i need another called style.
section is the master table, their are something like 17 categories, 14 belonging to sectionid1 and the others to sectionid2.
now i have style which is a child of categories and for all but row that link to sectionid2, theirs a mere two options for style. but for those three children of sectionid2 theirs like 10 each.
now here's where it helps to understand the implementation, i have a form and i click the section and the relevant catergory appears and you click the cat and the relevant style appears, this is done with dhtml. (all in theory so far).
given that implemation what's the best way to store the styles? i was thinking of just making a table with styleid, stylename, catid, description.
however to make the dropdowns without going nuts on the queries am i going about it the best way?
section is the master table, their are something like 17 categories, 14 belonging to sectionid1 and the others to sectionid2.
now i have style which is a child of categories and for all but row that link to sectionid2, theirs a mere two options for style. but for those three children of sectionid2 theirs like 10 each.
now here's where it helps to understand the implementation, i have a form and i click the section and the relevant catergory appears and you click the cat and the relevant style appears, this is done with dhtml. (all in theory so far).
given that implemation what's the best way to store the styles? i was thinking of just making a table with styleid, stylename, catid, description.
however to make the dropdowns without going nuts on the queries am i going about it the best way?