[aqw]

I have this result set:

Code:

title           parentcat_ids     base_title 
ASP                12            ASP         
Discs              12,10         ASP         
Java               12,11         ASP         
JSP                3             JSP         
PHP                1             PHP         
Books              1,5           PHP         
XML                1,6           PHP         
Ad management      1,7           PHP         
Abraham's Report   1,7,13        PHP        
XXL                1,7,14        PHP         
Zimmick            1,7,14,15     PHP         
Hattrick           1,7,14,16     PHP         
Junkyfood          1,7,14,17     PHP         
Programs           1,7,9         PHP         
Ziggurat           1,7,9,18      PHP         
Traffic scripts    1,8           PHP         
XML's fall         4             XML's fall

...


And I want to have this result set: (I've delimited the rows to make them easier to see).

Code:

title                   parentcat_ids        base_title
ASP                     12                   ASP         
Discs                   12,10                ASP         
Java                    12,11                ASP          


JSP                     3                    JSP         
 

PHP                     1                    PHP            
Ad management           1,7                  PHP         
Abraham's Report        1,7,13               PHP       
Programs                1,7,9                PHP         
Ziggurat                1,7,9,18             PHP     
XXL                     1,7,14               PHP            
Hattrick                1,7,14,16            PHP         
Junkyfood               1,7,14,17            PHP            
Zimmick                 1,7,14,15            PHP      

Books                   1,5                  PHP        
Traffic scripts         1,8                  PHP        
XML                     1,6                  PHP          


XML's fall         4             XML's fall

You have surely already noticed that the thing that needs to be done to the 1st result set is to sort the rows (belonging to a same parentcategory) with 'title'.

Suppose you got the first result set from the db. (I can't get any better result set from the DB. Please don't tell me I should have sorted it in the db first, it's just not possible).

Then create an array (multidimensional) simulating the 2nd result set. (With the help of mysql's sort functions etc.).

The real db has of course many more categories (around 5000).

I have tried longely but never succeeded

Thanks so much.

[aqw]

anyone knows?

[jordie]

Whats the difference between the two PHP groups?

so you want it in an array like:

Code:

array => group01 => 0 => title               => ASP
                         parentcat_ids  => 12
                         base_title       => ASP
                   1 => title               => Discs
                         parentcat_ids  => 12,10
                         base_title       => ASP
                   2 => title               => Java
                         parentcat_ids  => 12,11
                         base_title       => ASP
        group02=> 0 => title               => JSP
                         parentcat_ids  => 3
                         base_title       => JSP

etc etc ????????