List:General Discussion« Previous MessageNext Message »
From:hsv Date:May 25 2012 1:35pm
Subject:Re: category with parentid
View as plain text  
>>>> 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.
**************************************************************


Thread
category with parentidHaidarPesebe25 May
  • Re: category with parentidhsv25 May
    • Re: category with parentidAndrĂ©s Tello25 May
      • Re: category with parentidhsv26 May
    • Re: category with parentidPeter Brawley25 May
  • Re: category with parentidHaidarPesebe28 May
    • Re: category with parentidTsubasa Tanaka28 May
    • Re: category with parentidhsv28 May
    • Re: category with parentidhsv28 May
Re: category with parentidHaidarPesebe30 May
Re: category with parentidHaidarPesebe30 May
  • Re: category with parentidTsubasa Tanaka30 May