[PHP-DB] Re: Subject: Categories and Items query

2003-12-31 Thread Ali Van Doren
Neil, Just wanted to let you know that your advice worked like a charm! Thanks so much! Ali Neil Smth wrote: At 01:11 31/12/2003 +, you wrote: To: [EMAIL PROTECTED] Message-ID: <[EMAIL PROTECTED]> Date: Tue, 30 Dec 2003 12:30:06 -0500 From: Ali Van Doren <[EMAIL PROTECTED]>

[PHP-DB] Re: Categories and Items query

2003-12-30 Thread Ali Van Doren
in Both feature sets, then there are two rows in this table, one for each feature set. 3. To query this, join features and feature_set_features on feature_id and use where feature_set_id = 'standard' or whatever if is. Hopefully I haven't confused you too much. Lang Ali Van Dore

[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

[PHP-DB] Categories and Items query

2003-12-30 Thread Ali Van Doren
Hello, I am pretty new to PHP and MySQL, and am struggling with this particular page I would like to create. I am building a page which lists categories of house features (e.g. concrete, framing, foundation, etc.) and then the particular features that fall into those categories (e.g. the concr