Need help with PHP script logic

[garfield1]

Hi
I am trying to program for a login screen, I have succeeded somewhat but I am getting a blank screen. If you login with a user name and if it is wrong then it will directyou to a different page.

include("connectdb.php"); 

$rRes = mysql_query( 
   sprintf(        
   "SELECT * FROM register WHERE email = '%s' LIMIT 1",        
   mysql_real_escape_string($_POST['myemail'])    
   )
   );
   if(1 !== mysql_num_rows($rRes))
   {    
   header('Location: wrong.php');    
   exit;
  }

$aRec = mysql_fetch_assoc($rRes);
 printf(    
   '
    <strong>Type:</strong>%s<br />    
    <strong>State:</strong>%s<br />    
    <strong>Area:</strong>%s<br />    
    <strong>Description:</strong>%s<br />        
     <strong>ID:</strong>%s<br /> 
    ',
    $aRec['type'],    
    $aRec['state'],    
    $aRec['area'],    
    $aRec['desc'],        
    $aRec['ID']
    
 );

Any advice or suggestion on this. Thanks in advance.

[kelfro]

Hi
I think you should try echoing out the result of mysql_num_rows($rRes) to see what you get the value.
Or you can try changing this

if(1 !== mysql_num_rows($rRes))

To this:

if (intval(mysql_num_rows($rRes)) < 1)

This may work check it.

[Katty]

Hi
I feel that there is a problem in the following line of your program, can you please try replacing it.
now it is

if(1 !== mysql_num_rows($rRes))

try changing to

if (mysql_num_rows($rRes) == 0)

[Praetor]

Hi
If you need you can try the following code

include("connectdb.php"); 

if($_POST && !empty($_POST['myemail']))
{
	$email=mysql_real_escape_string($_POST['myemail']);
	$rRes = mysql_query( "SELECT * FROM register WHERE email = '$email' LIMIT 1");       
	if( mysql_num_rows($rRes) > 0)
	{
		$aRec = mysql_fetch_assoc($rRes);
		echo " <strong>Type:</strong>$aRec['type']<br />    
			   <strong>State:</strong>$aRec['state']<br />    
			   <strong>Area:</strong>$aRec['area']<br />    
			   <strong>Description:</strong>$aRec['desc']<br />        
			   <strong>ID:</strong>$aRec['ID']<br /> ";
	}
	else
	{ 
		header('Location: wrong.php');    
	}
}
else
	echo 'Nothing Posted!';

Any more problem do post back.