[PHP-DB] Re: Categories and Items query

2003-12-30 Thread Ali Van Doren
Thanks, Lang! I think I understand your description, and will try it tonight. Thanks so much for responding! :) Lang Sharpe wrote: Having a Standard only, Deluxe only and Both will lead to problems in the future. (i.e. what if you add in a Basic feature set?) What I would do is 1. Get rid of

[PHP-DB] Re: Categories and Items query

2003-12-30 Thread Lang Sharpe
Having a Standard only, Deluxe only and Both will lead to problems in the future. (i.e. what if you add in a Basic feature set?) What I would do is 1. Get rid of the "Both" row in feature sets. 2. Have another table called "feature_set_features" or something better. The table has two columns, Th

[PHP-DB] Re: Categories and Items query

2003-12-30 Thread Ali Van Doren
Well, I figured out how to do my nested loop, so now I think it's a fairly small problem that I have now: how to only select features that should show on the Deluxe Home Features page, or the Standard Home Features page. I have a table named feature_sets with three values (plus keys): both, sta