indexed array from recordset
I am trying to create a simple, indexed array from a recordset, but cannot seem to get it in the correct format.
I am retrieving a single field, EMail.
If I was to do this manually, it would look like
$emailarray = array('firstname.lastname@example.org', 'email@example.com','firstname.lastname@example.org');
and if i did a print_r($emailarray);
it would look like
Array (  => email@example.com  => firstname.lastname@example.org  => email@example.com )
which is exactly what i want
when i try and do the same using a recordset, i cannot get the same result.
If I try
$emailarray = array();
$emailarray = $row_rsmembersreplied;
} while ($row_rsmembersreplied = mysql_fetch_row($rsmembersreplied));
Array (  => Array ( [email] => firstname.lastname@example.org )  => Array (  => email@example.com )  => Array (  => firstname.lastname@example.org ) )
If I omit the  within the do..while loop. i get the correct format, but only one row returned