how to display tree structure from database???
| From: | Smita Manohar | Date: | Tue, 27 Aug 2002 08:32:47 +0000 |
| Subject: | how to display tree structure from database??? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-21382@lists.php.net to get a copy of this message | ||
hiii
im using php with mysql. i have one table for which i want to display tree structure.
for eg. table is like this...
person_id name parent_id
1 shyam 0 2 rohit 1 3 nikita 1 4 ram 0 5 ankit 4 6 jui 5 7 vicky 5 8 rekha 0 9 jay 6 10 kirti 8i want help for writing query to display all topnodes, parent, their childern and grand children thnx and regards, smita _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx