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:254633 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
