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