My user authentication code --
<?php
$useremail = $_POST['emailfield'] ;
$userpassword = $_POST['pwfield'] ;
require ('sqlauth2.php') ;
mysql_select_db($database, $con);
$sql = "SELECT * FROM userregistry WHERE email='".$useremail."' AND password='".$userpassword."'" ;
$run = mysql_query($sql) ;
$row = mysql_fetch_array($run) ;
if(mysql_num_rows($run) == 1)
{
echo "SUCCESS <br>" ;
}
else
{
echo "No login for you " ;
}
?>
Looks perfect, but I keep getting this error
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\bullet2\logincheck.php on line 10
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\bullet2\logincheck.php on line 12
No login for you
Any idea ?
Searched everywhere, couldn't find anything proper.
I know there is something wrong somewhere, can't seem to find it.
Help me out people, thanks !!!