使用id作为键，使用name作为数组的值 - Use id as key and name as value of the array

Use id as key and name as value of the array

本文关键字：使用数组 id name | 更新日期: 2023-09-27

我想更改mysql结果的格式。。。

[0] =>  
      [id]   => 1    
      [name] => King     
[1] =>  
      [id]   => 5
      [name] => Queen

到此格式：

[1] => King
[5] => Queen

但我不知道如何将mysql结果放在这样的格式中。

$teamSql   = "SELECT id, name FROM users WHERE  projectid = '1';
$teamQuery = mysql_query($teamSql);
$teamFetch= mysql_fetch_assoc($teamQuery);
// and now?

$teamSql   = "SELECT id, name FROM users WHERE  projectid = '1'";
$teamQuery = mysql_query($teamSql);
$teams = array();
while ($team = mysql_fetch_array($teamQuery))
{
    $teams[$team['id']] = $team['name'];
}

用于在PHP中显示结果，

使用foreach循环

类似foreach（$teamFetch为$teamFetched）｛

echo$teamFetched；

}

就是这样。