我想更改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 - 使用id作为键,使用name作为数组的值,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/8758895/

10-11 23:04
查看更多