Warning: Unable to jump to row 0 on MySQ

Anon

Warning: Unable to jump to row 0 on MySQL result index 2 in /usr/www/users/dillpeng/htdocs/register/check.php on line 65

why

trooper

Peng

You need to give more information. We can't help you out with just that posting

Gary Mailer

Anon

I generally get this error when I try to use a result set that is empty and try and use

$val = mysql_result($result, $i, 'fieldname');

Anon

//check.php
function user_login($user_name,$password)
{
global $feedback;

if (!$user_name || !$password) {
	$feedback .=  ' ERROR - Missing user name or password ';
	return false;
} else {
	$user_name=strtolower($user_name);
	$password=strtolower($password);
	$sql="SELECT * FROM user WHERE user_name='$user_name' AND password='". md5($password) ."'";
	$result=mysql_query($sql);
	if (mysql_num_rows($result) < 0){
		$feedback .=  ' ERROR - User not found or password incorrect ';
		return false;
	} else {
		if (mysql_result($result,0,'is_confirmed') == '1') {
			user_set_tokens($user_name);
			$feedback .=  ' SUCCESS - You Are Now Logged In ';
			return true;
		} else {
			$feedback .=  ' ERROR - You haven\'t Confirmed Your Account Yet ';

			return false;
		}
	}
}

}

//pass.php

  include( "check.php" );


 if ( user_login( $user_name, $password) )
{ 

     echo "".$feedback."";
}
else
  {

echo "".$feedback."";
}
</script>

//show the message above