Posting data from MySQL into an Array

[QRator]

Hey guys

I am not quite sure how to go about this, but here goes.

I am extracting usernames and emails addresses from a DB.

I now need to add these into an array called $emailList.

This is my code ...

$sql = "SELECT username,email FROM table";
$result = mysql_query($sql);
while($row = mysql_fetch_object($result)){
  // What do I need to put here in order to add the results into the array called $emailList?
}

the array must look something like so ...

Array
(
    [username1] => [e-mail]
    [username2] => [e-mail]
)

[rincewind456]

while($row = mysql_fetch_object($result)){
      $emailList[] = $row

}

Should work.

[QRator]

thank you very much, worked perfectly 😛