On 2012-05-25 8:35 AM, hsv@stripped 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.
> **************************************************************
>
>
>
