Resource id #4 in all case while username and password is not correct

[soumyagnair]

Hi all,

i'm a new user of PHP,

at the moment, i have queries regarding the "Resource id #4"

following is my code

<?php
$con=mysql_connect("localhost","root","","register");
$db=mysql_select_db("register",$con);
 
 
if(isset($_POST['login']))
{
$username=$_POST['uname'];
$password=$_POST['pwd'];
 
 
 
 
$sql1 = "SELECT * FROM `reg` where username='$username' AND password='$password'";
 
 
$query1= mysql_query($sql1);
echo $query1;
 
 if (($query1)>0)
 {
while ($rows=mysql_fetch_array($query1))
{
 
 
    $_SESSION['unme']=$rows['username'];
    $_SESSION['pwd']=$rows['password'];
    $_SESSION['photo']=$rows['photo'];
 
    echo $_SESSION['unme'];
     echo $_SESSION['pwd'];
      echo $_SESSION['photo'];
 
 
 
 
if (($username==$_SESSION['unme'])&&($password==$_SESSION['pwd']))
{
    /*header("location:home.php?firstname=".$_SESSION['unme']);*/
    echo "ghngjh";
 
}
 
}
 }
else
{
    echo "nooooo";
}
 
 
}
 
mysql_close($con);

[Dormilich]

that’s correct. if you print out a resource data type, that is the output you get.

you explicitly have to fetch the row count with mysql_num_rows()


PS. the mysql functions are deprecated, use PDO or MySQLi instead.