SELECT * FROM table WHERE ParentID = "99"
HTH
Peter
-Original Message-
From: Alex Pilson [mailto:[EMAIL PROTECTED]
Sent: 29 July 2003 06:06
To: [EMAIL PROTECTED]
Subject: Category System schema
Does anyone know the best schema to achieve a multi-level category system?
I nee
Does anyone know the best schema to achieve a multi-level category system?
I need a person to be able to add categories on the fly, but then
also specify sub categories and even possibly sub-categories of
sub-cats. I have found two possible ways inside one table with using
parentID, groupID, et
