> >Subject: [wdvltalk] Re: Creating category listings in SQL > > > > > >scott, how many levels do you need to support? > > > >main, sub, and subsub are three levels > > > >if that's as deep as you ever let it get, i'll give you the query to get > >what you want all in one shot > > > >rudy
I want to be able to support an infiniste amount of sub categories, which is where the real problem lies. I'm not sure if I can do this with straight SQL, plus I'm using MySQL 3.23.41 so I don't think sub-queries are really allowed. --------------------------------------------- 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]
