Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given error

Question

The result of 'mysql_query' is a resource, right? Then why am I getting this error: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given on this piece of code? CODE:

$con = mysql_connect("localhost","root")or die("NO");
mysql_select_db($db_name,$con)or die("Not good");


$usernames=mysql_query("SELECT * FROM user_info WHERE Username='$user' AND Password='$password'");


$count=mysql_num_rows($usernames);

if($count==1){session_register("user");session_register("password");header("location:Login_Success.php");}
else{echo "<p style='color:red'>Wrong username or password!</p>";}

Also, I have a problem with my if...else statement. The else code appears before the if's.

**http://bobby-tables.com** – Amal Murali Sep 08 '13 at 11:57 — Amal Murali, Sep 08 '13 at 11:57
@MuhammadTalhaAkbar then how do i fix it? – Sep 08 '13 at 12:17 — , Sep 08 '13 at 12:17

score 1 · Accepted Answer · answered Sep 08 '13 at 12:03

1

your mysql connect should be like that

     mysql_connect('localhost', 'root', 'mysql_password');
                                        ^^^^^^^^^^^^^^^^----you forgot this

you forgot password.

and you should not use mysql but instead use PDO or MYSQLI.

if you use mysql_error() you can see whats wrong easilly . like that:

 $con = mysql_connect("localhost","root","mysql_password")or die(mysql_error());

answered Sep 08 '13 at 12:03

echo_Me

37,078
5
58
78

it's nothing wrong with the connect! and i get the same results if i use mysqli – Sep 08 '13 at 12:12
try add this after your query `if(!$usernames) mysql_error() ;` and say what error you got. – echo_Me Sep 08 '13 at 12:15
thanks @echo_me it said that the table doesn't exist! – Sep 08 '13 at 12:22
nice then you know whats the problem :) , table doesnt exist. if its solved make sure to accept answer. – echo_Me Sep 08 '13 at 12:32
hey guys it was a problem in phpmyadmin i messed up the tables. – Sep 10 '13 at 13:13
oh and @echo_Me i don't have enough reputation to accept the answer. :( – Sep 10 '13 at 13:15

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given error

1 Answers1