将id用作数组的键，将name用作数组的值

Question

我想更改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?

Answer 1

$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'];
}

Answer 2

为了用PHP显示结果，

使用foreach循环

如foreach ($teamFetch as $teamFetched){

echo $teamFetched；

}

就是这样..