Store mysql query result in an array

This example is to store id’s from event table into an array variable.

$finals = mysql_query(“SELECT id FROM event WHERE efinal=’Y'”);

while ($rowfinal = mysql_fetch_array ($finals)) {
$arr_final[] = $rowfinal[‘id’];
}