Please help mysql_num_rows() expects parameter 1 to be resource

Question

ichinpogs1 0 Newbie Poster

13 Years Ago

Hi sir pls help i have an error in line 13 .. and still i don't no where can i find this error...

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\login.php on line 13

<?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("SELECT * FROM users WHERE username = '$username'");

                          $numrows = mysql_num_rows($query);
                          echo $numrows;

                        }
                        else

                             die("Please enter a username and password");


?>

php

5 Contributors
16 Replies
308 Views
1 Year Discussion Span
Latest Post 12 Years Ago Latest Post by ruby21

All 16 Replies

pritaeas 2,194 ¯\_(ツ)_/¯

13 Years Ago

It means you query failed. Add after line 11:

if (!$query) die(mysql_error());

Let us know if there is an error.

sam-i-am 0 Newbie Poster

13 Years Ago

Hi sir pls help i have an error in line 13 .. and still i don't no where can i find this error...

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\login.php on line 13

<?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("SELECT * FROM users WHERE username = '$username'");

                          $numrows = mysql_num_rows($query);
                          echo $numrows;

                        }
                        else

                             die("Please enter a username and password");


?>

for mysql_num_rows() to return a value the supplied argument must be a mysql result set.

there is an error in your sql
try changing the line

$query = mysql_query("SELECT * FROM users WHERE username = '$username'");

to

$query = mysql_query("SELECT * FROM users WHERE username = '".$username."'");

Edited 13 Years Ago by Ezzaral because: Snipped url. Keep it on site.

muralibobby2015 17 Posting Pro

13 Years Ago

you got

" Table 'phplogin.users' doesn't exist"

this message.
but you wrote your dbname

"phplogin"

and tablename

"user"

check your table name users or user

muralibobby2015 17 Posting Pro

13 Years Ago

you got "users" table doesn't exist. but your table name is user. remove 's'.

Edited 13 Years Ago by muralibobby2015 because: n/a

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

ichinpogs1 0 Newbie Poster · Answer 1 · 2010-08-14T09:43:59+00:00

It means you query failed. Add after line 11:
if (!$query) die(mysql_error());
Let us know if there is an error.

hi Master! i do what u said

$query = mysql_query("SELECT * FROM users WHERE username ='$username'");
     if (!$query) die(mysql_error());

and i got this message " Table 'phplogin.users' doesn't exist"

if the table that he means is the error well i have one already..

is this the table that he mean in the Database i have "phplogin" under that is the "user" the table is look like this.

id    username   password
	   	                       1    alex 	  abc

Sorry for this i am trying hard to learn this ..

ichinpogs1 0 Newbie Poster · Answer 2 · 2010-08-14T10:34:52+00:00

when i add this if (!$query) die(mysql_error()); now i got this error
"Table 'phplogin.users' doesn't exist"

<?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("SELECT * FROM users WHERE username = '$username'");

 if (!$query) die(mysql_error());

                          $numrows = mysql_num_rows($query);
                          echo $numrows;

                        }
                        else

                             die("Please enter a username and password");


?>

ichinpogs1 0 Newbie Poster · Answer 3 · 2010-08-14T11:28:27+00:00

you got
" Table 'phplogin.users' doesn't exist"
this message.
but you wrote your dbname
"phplogin"
and tablename
"user"
check your table name users or user

I got the table name

My Database name

"phplogin(1)"

table name
"user"

and i got this error message " Table 'phplogin.users' doesn't exist "
what am i suppose to replace?

muralibobby2015 17 Posting Pro · Answer 4 · 2010-08-14T11:37:48+00:00

use this query

$query = mysql_query("SELECT * FROM user WHERE username = '$username'");

ichinpogs1 0 Newbie Poster · Answer 5 · 2010-08-14T11:45:37+00:00

you got "users" table doesn't exist. but your table name is user. remove 's'.

first i don't no where..
where can i find this "phplogin.users" ? in my notepads, or this URL bellow

this is the URL of of my phpmyaddmin i use wamp 2.0 :
http://localhost/phpmyadmin/index.php?db=phplogin&token=62a5c4ce0affb95ca06ca4421ca397ba

ichinpogs1 0 Newbie Poster · Answer 6 · 2010-08-14T11:49:24+00:00

waaaaaaaaaaaaaaaa its working now! what happen... thank u ^^

muralibobby2015 17 Posting Pro · Answer 7 · 2010-08-14T11:50:48+00:00

use this query its enough.

$query = mysql_query("SELECT * FROM user WHERE username = '$username'");

ichinpogs1 0 Newbie Poster · Answer 8 · 2010-08-14T11:54:23+00:00

use this query

$query = mysql_query("SELECT * FROM user WHERE username = '$username'");

its working now it respond "1"

i don't see any different between this

$query = mysql_query("SELECT * FROM user WHERE username = '$username'");

and this and this code that i post

$query = mysql_query("SELECT * FROM users WHERE username = '$username'");

muralibobby2015 17 Posting Pro · Answer 9 · 2010-08-14T12:02:05+00:00

you don't see any difference. you got "users" table does not exists. but your table name is "user". so how you can selects rows from 'users' table. you wrote like this

$query = mysql_query("SELECT * FROM users WHERE username = '$username'");

just i changed table name "users" as "user"

$query = mysql_query("SELECT * FROM user WHERE username = '$username'");

ichinpogs1 0 Newbie Poster · Answer 10 · 2010-08-14T12:14:54+00:00

oh i see so that's the table to be adjusted yay! thank u so much .. i feel so haaaapy :)

muralibobby2015 17 Posting Pro · Answer 11 · 2010-08-14T12:20:25+00:00

muralibobby2015 17 Posting Pro

13 Years Ago

welcome.mark as solved.

ruby21 0 Newbie Poster · Answer 12 · 2012-01-15T09:34:20+00:00

what is the meaning of this mysql_num_rows() expects parameter 1 to be resource, boolean given in

Please help mysql_num_rows() expects parameter 1 to be resource

Recommended Answers Collapse Answers

All 16 Replies

Recommended Answers