使用PHP从SQL Select输出关联数组

Question

我想我的脑海中一片空白，但基本上，我想从各种sql结果创建一个关联数组

该数组需要如下所示：

$people = array(
     "+1123456789" => "Phil"
);

下面是我的SQL语句

$sql = " SELECT phonenumber6, firstName FROM members WHERE departmentID = 4 AND phonenumber6 <> '+1';";

谢谢!

编辑:此外，sql语句还可以选择多个行

$sql = " SELECT phonenumber6, firstName FROM members WHERE departmentID = 4 AND phonenumber6 <> '+1';";

                $result = mysql_query($sql);

                while($row=mysql_fetch_assoc($result)) {
                  echo $people[$row['phonenumber6']] = $row['firstName'];
                }

Answer 1

while($row=mysql_fetch_assoc($query)) {
  $people[$row['phonenumber6']] = $row['firstName'];
}

附录

不知道你想要回声什么。无论如何，正确的语法是：

while($row=mysql_fetch_assoc($query)) {
  $people[$row['phonenumber6']] = $row['firstName'];
  echo $row['phonenumber6']. '=> '.$row['firstName']."<br />\n";
}

Answer 2

这将为您提供一个来自mysql结果集的关联数组：

$assoc = mysql_fetch_assoc ($res);