Help - Warning: Mysql_num_rows(): Supplied Argument Is Not A Valid MySQL

hi

i have also created the following php code an recieved the error

warning: mysql_num_rows(): supplied argument is not a valid mysql result resource in c:\wamp\www\zetechnew\stafflogi on line 26


the code is as follows:

start or phpcode
$host="localhost"; // host name
$username="wycliff"; // mysql username
$password="dawa"; // mysql password
$db_name="zetech"; // database name
$tbl_name="staff"; // table name

// connect to server and select databse.
mysql_connect("$host" "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select db");

// username and password sent from form
$myusername=$_post['staff name'];
$mypassword=$_post['password'

// to protect mysql injection (more detail about mysql injection)
$myusername = stripslashes($myusername);
$mypa = stripslashes($mypassword);
$myus = mysql_real_escape_string($myusernam = mysql_real_escape_string($mypasswor * from $tbl_name where staffname='$myusername' and password='$mypassword'";
$res mysql_num_row is counting table row
$count=mysql_num_rows($resul if result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// register $myusername, $mypassword and redirect to file "login_success.php"
session_re
header("location:aboutus.php" {
echo "wrong username or password";
}
?>

kindl help

ok the reason why you are getting this error is simply because MYSQL cannot connect to your database. take the following steps to make sure you checked everything:

1. check for mispelling
2. make sure you typed the correct table or field name
3. you may have a character that mysql cannot recognize like a ' apostrophe for example
4. if your script worked before, i suggest undo what you did and see what is the difference

98% percent of the time, if you've connected to your database before with the same script, it mostly likely you have a mispelling or you are trying to get data from the wrong table or field.

Courtesy of our friends at www.webune.com

Wallpaperama Team.


https://www.wallpaperama.com/forums/help-warning-mysql-num-rows-supplied-argument-is-not-a-valid-mysql-t703.html