[Help] warning:mysql_num_rows() expects parameter 1 to be resource

[Adhe_Arie15]

Hello everyone! I'm new in this forum.

I'm having a problem with my coding : when I execute the code below >>

 

$cek_login=mysql_num_rows($login);
if (empty($cek_login))
{
echo "";
echo "";
}
else
{
//daftarkan ID jika user dan password BENAR
while ($row=mysql_fetch_array($login))
{
//$id=$row[0];
//session_register('id');
//CHANGE 1:
//---------
$_SESSION["id"] = $row[0];

}
echo "";
echo "";
}


?>
' target='_blank'>session_start();
session_destroy();
include "koneksi.php";

$login=mysql_query("SELECT * FROM admin WHERE username='$_POST[username]' AND password='$_POST[password]'");
$cek_login=mysql_num_rows($login);
if (empty($cek_login))
{
echo "";
echo "";
}
else
{
//daftarkan ID jika user dan password BENAR
while ($row=mysql_fetch_array($login))
{
//$id=$row[0];
//session_register('id');
//CHANGE 1:
//---------
$_SESSION["id"] = $row[0];

}
echo "";
echo "";
}


?>

 

After that this error come out : 

warning:mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\project\cek_login.php on line 7

[dalecosp]

 

After that this error come out : 

warning:mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\project\cek_login.php on line 7

This means that $login is not a valid database resource, your query on line one isn't returning anything.

[cyberRobot]

Did you try using mysql_error() to see if the query results in an error?

http://php.net/manual/en/function.mysql-error.php