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(); }