Help for this page
$sqlstatement="SELECT Table1.Name, Table1.Address, Table1.City, Table1.State, Table1.ZIP, Table1.Phone FROM Table1 WHERE Table1.BusType = 'ARCHITECTS'"; $sth = $dbh->prepare($sqlstatement);
my @lines = <DATA>; my $line; ... Table1.State, Table1.ZIP, Table1.Phone FROM Table1 WHERE Table1.BusType = '$line'; $sth = $dbh->prepare($sqlstatement);