----- Original Message -----
From: "olinux" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 29 October 2001 08:16
Subject: [PHP-DB] category structure
> anyone have any ideas on this
> I have a table of directory categories
> id | parentid | category
> 1 | 0 | blah1 top
> 2 | 1 | blah2 sub
> 3 | 1 | blah3 sub2
> 4 | 3 | blah4 sub2->sub
> I want to hit the DB only once so i select all and
> drop into array
> Now i've created array with these like so:
> But now what?
> trouble is that
> $msub is a sub category of $msub
> so i can't just run thru and print the array - need to
> manipulate a little.
> Any ideas? [or even a beeter way to do this?]
What you are asking is a fairly common requirement, with well-known solutions.
In what format do you require the output printed?
Do you know what a "tree" data structure is, and how to 'walk the tree'?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]