php - array to string 转换错误，需要先 explode 再内爆

Question

我想分解一个数组，读取每个值并将它们打印回数组中...

我不明白我哪里错了。请帮助我..这是我的代码..

我收到一个数组到字符串的转换错误

$query="SELECT categories FROM shops";
$result = mysql_query($query);  
while($column = mysql_fetch_assoc($result)){
    $categories=explode(",",$column['categories']);
    foreach($categories as $value){
        $new_query="SELECT name from categories where id='$value'";
        $name = mysql_query($new_query);    
        $name_column= mysql_fetch_assoc($name);
        array_push($shops_list,$name_column);

    }
}
echo implode(",",$shops_list);

Answer 1

$shop_list 未定义，在此行 array_push($shops_list,$name_column); 中使用它之前。而且，这一行

    array_push($shops_list,$name_column);

需要，因为您需要提及 key name，

    array_push($shops_list,$name_column['name']); //or better
    $shop_list[] = $name_column['name'];