RE: [PHP] Category and sub-category logic
| From: | Chris W. Parker | Date: | Thu, 14 Aug 2003 22:27:40 +0000 |
| Subject: | RE: [PHP] Category and sub-category logic | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-159619@lists.php.net to get a copy of this message | ||
Ryan A <mailto:ryan@jumac.com>
on Thursday, August 14, 2003 3:21 PM said:
Read this http://www.sitepoint.com/article/1105
and you will know what
you should do.
The database organization you want to use is called Modified Preorder
Tree Traversal. It takes only one table to create all the relationships
needed.
If you have any questions about this technique send me an email as I've
got some experience with this method.
Chris.
p.s. The easiest way (I think) to learn this method is to actually use
your own data and draw it out on a piece of paper (as opposed to trying
to visualize the map in your head).