From: hsv Date: May 25 2012 1:35pm Subject: Re: category with parentid List-Archive: http://lists.mysql.com/mysql/227537 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" >>>> 2012/05/25 14:57 +0700, HaidarPesebe >>>> 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 <<<<<<<< If the degree of subordination is a number in your record, try function REPEAT (output concatenated to A or B), or LPAD. ************************************************************** Scanned by MailScan AntiVirus and Content Security Software. Visit http://www.escanav.com for more info on eScan and X-Spam. **************************************************************