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 8 i 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php