>Well... I can't figure out how to use the "order_by" column >I've put into each real estate office table. > >Let's say (to make this simpler) that I've got six tables. > >1 - hmls_offices >2 - hmls_lots >3 - hmls_homes > >4 - smlc_offices >5 - smlc_lots >6 - smlc_homes >
It looks like you don't have the tables right. If it were me, I'd have a listingtypes table. Types are hmls, smlc Then you can use an offices table, linking it to the types table. Then do the same with lots and homes. my .02 at first glance. Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305585 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
