$sth = $db_handle->prepare("select foo from bar where id = ?") 
  or die( $db_handle->errstr );

$id = 17; ## or whatever

$sth->execute( $id ) or die ( $sth->errstr() );

$baz = $sth->fetchrow_hashref();