See, there I go again not making my self clear. The table actually has more than just makes and models of cars. It has antiques, autos, furniture, blah blah. each parent category has it's child category and each child has it's own child. As an example, Antiques would have a child of asian antiques and it would have a child of all the different asian antiques you could think of. I hope this makes more sense. Anyhow the first group of childs I can refer back to their parent, but the second group of childs are referenced back to the child of the parent and not the parent directly.
Doug ----- Original Message ----- From: "Jim Wright" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Thursday, September 28, 2006 9:43 AM Subject: Re: Arghhhh!! > Doug Brown wrote: > > Hey Jim...I have one more quick question for you. > > > > As I stated before I have just the one table to display the makes and models > > for the menu, and I am kinda dumbfounded as to how to display all the makes > > on one page with their corresponding models beneath them. Can this be > > accomplished with one table? > > > > IE: > > > > cat_id > > category > > parent_id > > > > Right now the data looks like so > > > > cat_id category parent_id > > 1 chevy null > > 2 ford null > > 3 Camaro 1 > > 4 Escort 2 > > Something like... > > SELECT a.category AS make, b.category AS model > FROM categories a LEFT JOIN categories b ON a.cat_id = b.parent_id > WHERE a.parent_id IS NULL > ORDER BY a.category,b.category > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254636 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
