Data from MySQL to be converted to Array for multiples uses

[passagewds]

I want to convert an array from a database (a list of specific members) to become an array so that I can use the array in multiple select lists.

I bet there is a real simple solution to do this... let's see who is the first one to point it out.

Mikey

[barand]

$sql = "select id, name from members order by name";
$result = mysql_query($sql);
$n = 0;
$members = array();
while (list($id, $name) = mysql_fetch_row($result)) {
    $members[$n]['id'] = $id;
    $members[$n]['name'] = $name;
    $n++
}

hth