Php Group by problem.

[Nubelle]

I have a database table and I want to retrieve table data by grouping two columns , I checked this but I was not able to find a solution ? Is there any method to do this. I want to do this from php side , not mysql

[root]

Not clear about your columns ? which columns you wants to group ??

[Nubelle]

@root root I want to group data by year and tyepe, I tried to do it using mysql. but failed.

[root]

Okay i'll try to find a solution .

[dev_lak]

@Nubelle did you get any error?

[KrissSachintha]

Did group by year,type throwed an error?

[root]

$array = [];

//$table_data is mysql returned array, you can change this whatever you want
foreach($table_data as $row) {
    $key = $row['type'] . '-' . $row['year'];
    if (!isset($array[$key])) {
        $array[$key] = $row;
    }
}

Try with this , i think this is correct solution for your issue.

[Nubelle]

@dev_lak No when I add groupBy function mysql said to disable some features , when I disable them other functions not working

[Nubelle]

@KrissSachintha No when I add groupBy function mysql said to disable some features , when I disable them other functions not working

[Nubelle]

@root Thanks , let me try this

[Nubelle]

@root hi root this is working , Thanks

[root]

@Nubelle

Ohh great bro, i'm very happy to help you.

[Nubelle]

Thanks all