my $c_first = $query->param('c_first');
my $c_address = $query->param('c_address');
my $sql = "SELECT id FROM names WHERE first = '$c_first'";
my $sth = $dbh->prepare( $sql );
if ( $sth && $sth->execute() ) {
while ( my $row = $sth->fetchrow_arrayref() ) {
print( "$c_first => " . $row->[0] . "\n" );
}
$sth->finish();
}
####
my $sql = "SELECT id FROM names WHERE first = ?";
my $sth = $dbh->prepare( $sql );
if ( $sth && $sth->execute( $c_first ) ) {
while ( my $row = $sth->fetchrow_arrayref() ) {
print( "$c_first => " . $row->[0] . "\n" );
}
$sth->finish();
}
####
$c_first = $dbh->quote( $c_first ); # make O'Brian safe
my $sql = "SELECT id FROM names WHERE first = $c_first";
my $sth = $dbh->prepare( $sql );
if ( $sth && $sth->execute() ) {
while ( my $row = $sth->fetchrow_arrayref() ) {
print( "$c_first => " . $row->[0] . "\n" );
}
$sth->finish();
}