Building array from db question

[Anon]

hey all.. This worked yesterday when there were only two records in the db.. When i imported all 700 of them this morn i keep getting errors.. here is the code. Really short.. but not working for some reason.. Keep getting undefined variable email???

<?
$connection = odbc_connect("otsego", "dbaccess", "dbaccess");
$query = "Select email from basic";
$result = odbc_do($connection, $query);

while(odbc_fetch_row($result)){
$email[] = odbc_result($result,1);
}
$email = implode("; ", $email);

print("<a href='mailto:$email'>click here to email the group</a>");

?>

Thanks Much!

[amcgrath]

Try this instead:
while($row = odbc_fetch_row($result)){
$email[] = $row["email"];
}

[Anon]

hi,

you defined $email inside the while block. is the while-block gone then all variables declared inside the while-block are gone. to get your script working, define the $email-var outside the while block.