SELECT * FROM users WHERE name = ? AND pass = ?

##</code><code>##

@row_ary = $dbh->selectrow_array("SELECT * FROM users WHERE name = ? AND pass = ?", undef, @binding_values);

##</code><code>##

SELECT 1 FROM users WHERE name = ? AND pass = ? #replace * with 1

##</code><code>##

  if($dbh->selectrow_array("SELECT * FROM users WHERE name = $uname_q AND pass = $pword_q")){
        ($userid) = $dbh->selectrow_array("SELECT userid FROM users WHERE name = $uname_q AND pass=$pword_q");