note 51868 added to function.mysql-num-rows

// this works properly $query = "SELECT first_name FROM users_tbl WHERE user_id='$user_id' AND password = '$p0' "; $result = mysql_query($query, $connection) or die ("<p class=err>Error - Query failed: ".mysql_error()."</p>"); $num_rows = mysql_num_rows($result); if ($num_rows){ while ($myrow = mysql_fetch_row($result)){ $first_name = $myrow[0]; print ("<p>Line:".__LINE__." num_rows:$num_rows first_name:$first_name <br> $query</p>"); } }else{ print ("<p>Password error.</p>"); } // Here 1 row is returned with a value of 0 when the password is wrong rather than reporting the password error. $query = "SELECT COUNT(first_name) FROM users_tbl WHERE user_id='$user_id' AND password = '$p0' "; $result = mysql_query($query, $connection) or die ("<p class=err>Error - Query failed: ".mysql_error()."</p>"); $num_rows = mysql_num_rows($result); if ($num_rows){ while ($myrow = mysql_fetch_row($result)){ $count_first_name = $myrow[0]; print ("<p>Line:".__LINE__." num_rows:$num_rows count:$count_first_name <br> $query</p>"); } }else{ print ("<p>Password error.</p>"); } ---- Manual Page -- http://www.php.net/manual/en/function.mysql-num-rows.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+51868 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+51868&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+51868&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+51868&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+51868&report=yes&reason=useless Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+51868&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+51868&report=yes Search -- http://master.php.net/manage/user-notes.php