如果其中一个字段被分组，则不获取表中其他字段的所有结果

Question

I am grouping the model field in cars table ,but i am getting only one,one result ,istead of all , from each differend grouped by models.

suppose there are three 1990,19190,1990 under moldel field and three cars suzuki,honda,tyota are undel car_name whose model is 1990 .but I am getting results of only one car name under 1990 model. Plz help me.

         $sql=mysql_query("SELECT * FROM cars group by  model ");
    while ($row=mysql_fetch_array($sql)) {
       $car_name=$row['car_name'];
       $model=$row['model'];


            ?>

    <table>

        <tr>
            <td><?php  echo $model ?></td>   //here is displaying  1990.

        </tr >
        <tr  >
              <td> <?php   echo $car_name;  ?></td>    // but here is displayed only onr car name istead of all.

        </tr>

    </table>



    <?php

      }

Answer 1

When you group by a particular column, you are asking for just one row for each value of that column. If you want 1990 Honda and also 1990 Suzuki, you should use GROUP BY car_name, model to get all the unique combinations of this pair of columns.

BTW, does your model column contain years? Car models are names like Accord, Camry, Celica.

EDIT:

I think this is what you're looking for:

SELECT model, GROUP_CONCAT(car_name)
FROM cars
GROUP BY model