php mysql按年度分组,PHP MySQL的分组

this is my table

row | car_id | car_model | car_features |

1 1 CAR 1 Features 1

2 2 CAR 2 Features 2

3 2 CAR 2 Features 3

and i want to make it like

row | car_id | car_model | car_features |

1 1 CAR 1 Features 1

2 2 CAR 2 Features 2, Features 3

and this is my php mysql script:

$con = mysql_connect("localhost", "root", "root");

mysql_select_db("car", $con);

$format = mysql_query("SELECT c.* , p.*, d.*,f.* ,e.* FROM bsi_car_master c,bsi_car_type p, bsi_car_vendor d, bsi_selected_features f, bsi_car_features e WHERE c.car_type_id=p.id AND c.car_vendor_id=d.id AND c.car_id = f.car_id AND f.features_id = e.id");

$row = 1;

while($srow = mysql_fetch_array($format))

{

blah blah blah....

}

?>

解决方案

Use GROUP_CONCAT with GROUP BY. Try this -

SELECT `row`, `car_id`, `car_model`, GROUP_CONCAT(`car_features`, ',')

FROM your_table GROUP BY `car_id`