PHP MySQL Group By result in array

Question

**********************
* id  *  typ  *  cl  *
**********************
* 1   *  1    *  1   *
* 2   *  4    *  1   *
* 3   *  7    *  1   *
* 4   *  2    *  2   *
* 5   *  4    *  2   *
* 6   *  8    *  2   *
**********************

hi frnz, I have a problem with mysql group by... tired of looking on the google so finally posting it here... my table structure is as showing above. I am using the following query...

$sql2w=executeQuery("select * from logo group by cl  ");
    while($line2=mysql_fetch_array($sql2)){ 
    echo $line2['typ'];
}

I am getting 1 and 2 in the result, but I want the result in this format.. 1,4,7 and 2,4,8 in string or in array format...

I hope I am clear what I want...

I am only getting the first row values of "typ" column but I want all rows values in array after grouping the "cl" column..

Thanks in advance

@eggyal: I'm guessing "friends"?

Madara's Ghost
– Madara's Ghost

2013-09-28 18:44:10 +00:00
Commented Sep 28, 2013 at 18:44 — Madara's Ghost
– Madara's Ghost, Commented Sep 28, 2013 at 18:44

eggyal · Accepted Answer · 2013-09-28 18:45:43Z

7

Use GROUP_CONCAT():

SELECT cl, GROUP_CONCAT(typ) FROM logo GROUP BY cl

See it on sqlfiddle.

answered Sep 28, 2013 at 18:45

eggyal

127k18 gold badges220 silver badges244 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

eggyal Over a year ago

@user2437172: Unless you alias it otherwise, the resultset column will be named GROUP_CONCAT(typ), so you would need to access it accordingly - echo $line2['GROUP_CONCAT(typ)'];.

Ivan Nikolaievskyi Over a year ago

as a variant you can use some alias for group concat for example GROUP_CONCAT(typ) as typs

Collectives™ on Stack Overflow

PHP MySQL Group By result in array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related