Creating An Array From A Mysql Query.

[00stuff]

Hi, I am trying to create an array from a mysql query that looks like this.

 

$people = array(

 

"8776546543" => "John Smith",

"8779876543" => "John Dow",

 

);

 

 

I need for that array to come from two columns of a mysql query and be placed on the $people variable. I am not sure how to do it. Can some one help me please?

[Pikachu2000]

Take this logic and apply it to your code.

 

$your_array = array();
while( $array = mysql_fetch_assoc($result) ) {
      $your_array[$array['first_field']] = $array['second_field'];
}