I have a database for the category id | name | parentid ---------------------- 1 | cat A | 0 2 | cat B | 0 3 | subcat A | 1 4 | subcat A | 1 5 | subncat B | 2 -------------------------
I want to display the result like this: 1. Cat A - Subcat A - Subcat A 2. CatB - Subcat B ask for help for this. Thanks for the help __________ Information from ESET NOD32 Antivirus, version of virus signature database 7165 (20120524) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com