filling array with while()

[fnsnoop]

hello,
I am trying to fill an array with data with a while statement, I cant seem to do it right and i am having trouble finding it in the manual. THis is what I have

$array = array();
while ( $row = mysql_fetch_array($result) ) {
	$array[] = $row['event_id'];
}

Alex

[Installer]

It should be working as long as your query is actually finding something and "event_id" is a valid column name. Try this:

$array = array(); 
while ($row = mysql_fetch_array($result)) {
    echo $row['event_id'] . '<br />'; 
    $array[] = $row['event_id']; 
}

[cafrow]

what I usually do is include a counter so I know how many i did.

$array = array(); 
$counter = 0;
while ( $row = mysql_fetch_array($result) ) { 
    $array[$counter] = $row['event_id']; 
    $counter ++;
}

[Installer]

Or you can use "echo mysql_num_rows($result);".