php mysql分组依据 [英] php mysql group by

问题描述

这是我的桌子

 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

我想让它变得像

 row  | car_id | car_model | car_features |
  1      1          CAR 1      Features 1
  2      2          CAR 2      Features 2, Features 3

这是我的php mysql脚本:

and this is my php mysql script:

<?php
    $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....
    }
?>

推荐答案

将GROUP_CONCAT与GROUP BY一起使用.试试这个-

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`

这篇关于php mysql分组依据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！