Store database column into array

[Fenhopi]

Hi, I'm trying to store the first+lastname from my mysql user datababase into arrays like this:

 

// Fill up array with names
$a[]="Anna";
$a[]="Brittany";
$a[]="Cinderella";
$a[]="Diana";
$a[]="Eva";
$a[]="Fiona";
$a[]="Gunda";
$a[]="Hege";
$a[]="Inga";
$a[]="Johanna";
$a[]="Kitty";
$a[]="Linda";
$a[]="Nina";
$a[]="Ophelia";
$a[]="Petunia";
$a[]="Amanda";
$a[]="Raquel";
$a[]="Cindy";
$a[]="Doris";
$a[]="Eve";
$a[]="Evita";
$a[]="Sunniva";
$a[]="Tove";
$a[]="Unni";
$a[]="Violet";

[litebearer]

Psuedo

 

1. connect to db

2. create query - select first, last from table

3.  result = mysql_query($query)

4. while row = result

    $array[] = $row['last'] . ", " . $row['first'];

  end while

 

[Fenhopi]

Thank you, sir!