On 2012-05-25 8:35 AM, h...@tbbs.net wrote:
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
It's a graph! See
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
PB
-----
<<<<<<<<
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
