Array help

[savagenoob]

Can anyone see why this isnt pulling all the rows that are in the database?

$empget = mysql_query("SELECT * FROM members WHERE office = '$office' AND agency = '$agency'") or die(mysql_error());
                $emp = mysql_fetch_array($empget);
                $emplist[] = $emp['member_id'];
                print_r($emplist);

$emplist should contain 3 entries but the print_r is only showing 1.

[Adam]

mysql_fetch_array only returns 1 row at a time, you need to loop through it:

 

while ($emp = mysql_fetch_array($empget))
{
    print_r($emp);
}

[mikosiko]

because you are reading only the first result and nothing else

your code should be something like

$empget = mysql_query("SELECT * FROM members WHERE office = '$office' AND agency = '$agency'") or die(mysql_error());
while ($emp = mysql_fetch_array($empget)) {
           $emplist[] = $emp['member_id'];
}

print_r($emplist);

 

the last line will print the complete array... if you want to work with that array you need to do it with a loop (for loop or foreach)

[savagenoob]

ugh... thank you.