> >> Is there a way in SQL to create a categorized listing from a table with > >> three fields like such: > > > >I have almost no idea what you mean :-) > > > >Grasping at straws... how about you use > > > >SELECT * FROM table > > ORDER BY > > cat, subcat, subsubcat > > > >Then the records should be in the order you want > > > >Bj
I'm basically trying to order them according to their parent_id, so that each catgory will have it's appropriate subcategories listed below it. I've been trying to work out a recusive subroutine that will load up a hash reference, but I can't seem to quite figure it out. I really don't have any code that works yet either. --------------------------------------------- Introducing NetZero Long Distance 1st month Free! Sign up today at: www.netzerolongdistance.com ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
