http://froogle.google.com/froogle?q=sql+for+smarties&btnG=Froogle+Search
Chapters 28 and 29 on Trees.
No another table is not a solution because what happens when you need yet
another sub-category.
I could explain it to you but I'd do a very poor job compared to the
chapters in the book above.
You can achieve using LIMIT option with the select stmt.
Regards,
Joseph
>-Original Message-
>From: Andrew Maynes [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, February 05, 2003 11:22 PM
>To: MySQL-Lista
>Subject: query produces a navigation
>
>
>I have a set of records in a mysql table
I would keep it in one table. Structured properly, you could then have
groups, sub-groups and categories, creating a hierarchy as deep as you
want. It's more for future proofing your database than anything else.
Just add two more columns to your table, one for a parent id and one to
indicate wh
