MySQL in a Nutshell

Name

selectrow_arrayref( )

Synopsis

$database_handle->selectrow_arrayref($sql_statement[, 
                                     \%attributes, @values])

This returns a reference to an array of one row from the results of an SQL statement given. This method combines prepare( ), execute(), and fetchrow_arrayref( ). An optional second argument can specify any of the attributes allowed for a statement handle. If placeholders are used in the SQL statement, their values must be given as an array for the third argument.

...
my $sql_stmnt = "SELECT title, author
                 FROM books WHERE book_id = ?";
my $book = $dbh->selectrow_arrayref($sql_stmnt,
                                    undef, '1234');
my ($title, $author) = @$book;
print "$title by $author \n";