[RESOLVED] creating an array

[NoBullMan]

Hi,
I need to create an array indexed by one of the values returned from query.

$query = "SELECT ID, Name, Number FROM Table";

I want to store the result in an array indexed by "ID" so I can refer to it as $arr['ID'].

I want to be able to get a selectedIndex.value of a dropdown and use it as index to this array to get other values, such as Name and Number.

Thanks.

[Installer]

Like this:

$query = "SELECT ID, Name, Number FROM Table";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
    $arr[$row['ID']] = array('Name' => $row['Name'], 'Number' => $row['Number']);
}