output an associative array, from SQL Select with PHP

Question

I think my mind is just drawing a blank, but basically, I want to create an associative array from various sql results

The array needs to look like:

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

Here is my SQL Statement

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

Thanks!

Edit: Also, there can be multiple rows that were selected by the sql statement

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

dynamic · Accepted Answer · 2011-06-04 20:15:13Z

3

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

Addendum

Dunno what you want to echo. Anyway the right syntax is:

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

edited Jun 4, 2011 at 20:15

answered Jun 4, 2011 at 20:08

dynamic

48.2k56 gold badges163 silver badges236 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

AJ. Over a year ago

you need to set an avatar, the world needs to know what lightning incarnate looks like L-/

dynamic Over a year ago

@AJ: I will explain you why I am doing this (if you want). (in pvt of course)... lol anyway :)

Bill Over a year ago

Cool thanks... is there any way to make sure I'm doing it right to echo it out? This is what I tried (See edit above)

Bill Over a year ago

Because it wasn't working... but it was because of another issue I had... not that. Thanks!

GSerg · Accepted Answer · 2011-06-05 11:49:42Z

0

This will give you an associated array from a mysql result set:

$assoc = mysql_fetch_assoc ($res);

edited Jun 5, 2011 at 11:49

GSerg

78.8k18 gold badges173 silver badges377 bronze badges

answered Jun 4, 2011 at 20:11

S. Albano

7077 silver badges21 bronze badges

Collectives™ on Stack Overflow

output an associative array, from SQL Select with PHP

2 Answers 2

Addendum

4 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Addendum

4 Comments

Comments

Related