$SQL = "select * from $resident_info_table where email!='' and email_alert = 'yes' order by ID desc";
&Do_SQL;
while ($pointer=$sth->fetchrow_hashref) {
$recipient = $pointer->{'email'};
&send_email;
}
$SQL2 = "select * from $resident_info_table where email2!='' and email2_alert = 'yes' order by ID desc";
&Do_SQL2;
while ($pointer2=$sth2->fetchrow_hashref) {
$recipient = $pointer2->{'email'};
&send_email;
}