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!");
?>
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!");
?>