Help me to get a query to display like this Category Subcategory Subcategory Subcategory ------------------ ------------------- ---------------- (n) Category Subcategory Category Category table --------------------- id Category_id Parent_id I hope u all got this .. Expecting reply -s .. Thanks in advance. Thank You, Reji Yahoo! India has a new look. Take a sneak peek http://in.yahoo.com/trynew [Non-text portions of this message have been removed]