$sth = $db->prepare("SELECT the_name FROM the_table WHERE id=?");
$sth->execute(3);
my ($the_name) = $sth->fetchrow_array;
[download]

my ($the_name) = $dbh->selectrow_array(<<SQL, undef, 3);
SELECT the_name FROM the_table WHERE id = ?
SQL
[download]

_________
broquaint