PHP Error ysql_num_rows() expects parameter 1 to be resource, boolean...

dalton metzler

New member
...given in C:\xampp\htdocs\kramansro\login? Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\kramansro\login.php on line 14

this is my code

<?php

$username = $_POST['username'];
$password = $_POST['password'];

if ($username&&$password)
{

$connect = mysql_connect("localhost","root","") or die ("Couldn't Connect");
mysql_select_db("phplogin") or die ("Couldn't find db");

$query = mysql_query("SEKECT * FROM users WHERE username='$username'");

$numrows = mysql_num_rows($query);

if ($numrows!=0)
{
while ($row = mysql_fetch_assoc($query))
{
$dbusername = $row['username'];
$dbpassword = $row['password'];
}
// check to see if they match
if ($username==$dbusername&&$password==$dbpassword)
{
echo "Your in";
}
else
echo "Incorrect passsword";


}
else
die("That username does not exisit!");

}
else
die("Please enter a username and a password!");

?>
 
Back
Top