Re: category with parentid

[hsv]

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