Bug #35411 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resourc

• Submitted: 18 Mar 2008 16:22
• Modified: 18 Mar 2008 16:43
• Reporter: matthew Thomas
• Status: Can't repeat
• Category: MySQL Websites: bugs.mysql.com
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any

[18 Mar 2008 16:22] matthew Thomas

Description:
I keep gettin this error can you help???

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /Applications/MAMP/htdocs/login.php on line 12
Login failed !

How to repeat:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /Applications/MAMP/htdocs/login.php on line 12
Login failed !

Suggested fix:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /Applications/MAMP/htdocs/login.php on line 12
Login failed !

[18 Mar 2008 16:43] MySQL Verification Team

Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

[9 Feb 2011 11:12] ranjan kaliya

getting this error...please help..!!

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\website\website\login.php on line 15.

<?php
require("newconnection.php");

$post_email= $_POST['email'];
$post_password= $_POST['password'];

if($post_email&&$post_password)
{
	if(strlen($post_email)>30||strlen($post_password)>15)
	die("Username or Password character length too long ");
	else
	{
	$post_password = md5($post_password);
	$login= sprintf("SELECT * FROM home WHERE email='%s' AND password='%s'",mysql_real_escape_string($post_email),mysql_real_escape_string($post_password));
	$rowcount= mysql_num_rows(mysql_query($login));
	echo $rowcount;
	}
	

}
else

die("Please Enter correct Email and Password.!")

?>