>>>> 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.
**************************************************************



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql