mysql_num_rows problem

[zodehala]

PHP Code:

$link = mysql_connect("localhost", "root", "123");
mysql_select_db("db", $link);
        
$result     = mysql_query("SELECT * FROM kul WHERE kuladi = root");
if(mysql_num_rows($result)!=1){
    echo "no user";

} 


gives following error. why?

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\tekoser\x.php on line 6

[BluePanther]

It's because your query is throwing an error and you're not catching it. wrap root in ' to define it as a string.

Use or die() statements or something else to catch mysql errors.

Also, you've just told the world your database root password. Remember to censor sensitive information when posting here.

[zodehala]

db user root and pass123

user ind db is root and his pass is 123

[BluePanther]

Originally Posted by zodehala

db user root and pass123

user ind db is root and his pass is 123

What? That's completely unrelated to my answer.

[BluePanther]

You edited your post as I replied. The user for the database is (and definitely should be) different from users stored in the database.

You're telling us your database user and pass! These forums are open to the public!

Your problem is in your sql query - a syntax error like I said.

[tangoforce]

Originally Posted by BluePanther

You edited your post as I replied.

I'm not seeing the traditional "Last edited.." line anywhere

[BluePanther]

Originally Posted by tangoforce

I'm not seeing the traditional "Last edited.." line anywhere

It doesn't appear if you edit within a certain time frame