Question

缅怀善良者

在忙忙.的牵引、操纵和操纵我的阵列时,我已经陷入了一个问题,我知道你会帮助我——同仁。

我有一个民族解放军,其中载有城市名称,一些城市在民族解放军上多次出现。

Im利用以下查询检索数据:

  $query = "SELECT cities from info_table WHERE store= kfc  ";

    $result = mysql_query($query);

while($city = mysql_fetch_array($result){
$total_cities_array[]=$city[0];
}

the problem is that in $total_cities_array some cities are a entered several when i ony need a single storage for every city. is there some php or mysql that i can use to fix this. Thank you.

Answer 1

$query = "SELECT cities from info_table WHERE store= kfc  GROUP BY cities";

Answer 2

SELECT DISTINCT cities from info_table WHERE store= kfc

友情链接