RE: hierarchical Structure in Mysql

2002-11-06 Thread Jon Frisby
it's sub(-sub)-categories." -JF > -Original Message- > From: Brent Baisley [mailto:brent@;landover.com] > Sent: Wednesday, November 06, 2002 11:44 AM > To: Walter D. Funk > Cc: [EMAIL PROTECTED] > Subject: Re: hierarchical Structure in Mysql > >

Re: hierarchical Structure in Mysql

2002-11-06 Thread Brent Baisley
Your structure is going to be a lot like a message board: Message Board-> Topic->Reply->Reply->... Where you can reply to someone else's reply or reply to the main topic. Your setup would have two tables, a "category" table and a "product" table. You get your cascade by each category having a fie

hierarchical Structure in Mysql

2002-11-06 Thread Walter D. Funk
Hi listErs! I need to design a database, under a hierarchical structure. This Mysql database aims to store a catalog in which I should be able to define: CATEGORIES -> SubCategories -> Sub-SubCategories -> Product the only problem, is that I usually use cascaded indexes, but in this case I sho