I NEED HELP ASAP PLS!!

bstudios

<?php
if(isset($POST['submit'])){
$username=addslashes($POST['username']);
$password=addslashes($_POST['password']);
include 'db.php';
$sql="SELECT * FROM users WHERE number='$username' AND password='$password'";
$query=mysql_query($sql);
$row=mysql_num_rows($query);
if($username=="admin" && $password=="access"){
setcookie("ADMIN","YES",'0','/');
header("Location: admin/index.php");
exit;
}
if($row==0){
$msg="No record for provided account ID";
}
else{
setcookie("USERNAME",$username,0,'/');
header("Location: members/index.php");
}
}

I keep geting error message

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/sorogate/public_html/royal/e-banking/royal/login.php on line 8

PLS HELP

Undrium

Greetings!

Reason why you get that error message is because your mysql_query()-function call returns false. This probably occurs because you have something wrong in your SQL-statement ($sql). If you want to know more about the error use mysql_error() after you mysql_query().

Do something like this:

$sql="SELECT * FROM users WHERE number='$username' AND password='$password'";
$query=mysql_query($sql);
echo mysql_error();
$row=mysql_num_rows($query);

Good luck. 🙂

Ps. Are you sure it is supposed to find username against "number"?
Ds.

NogDog

Welcome to the forums, bstudios. I would suggest that in future posts, in order to encourage others to help, that (a) you use a meaningful thread title (many people only read threads where the title indicates a subject that interests them) and (b) you make use of this forum's [noparse]

...

[/noparse] bbcode tags around your code samples, so that they are formatted and syntax-highlighted, making them much easier to read.