mysql_num_rows throws error

php database

[makeithappen]

please i need help

part of my script below:

13 $query = "Select * from members where member_id = '". $sponsorsid ."' and activated = 1" ;
14 $result=mysql_query($query);
15$num=mysql_numrows($result);


error is:

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/followup/public_html/default.php on line 15



i decided to add this line to it-


die( "Unable to query the database" . mysql_error());


this is the erroor message i get below with blank page

Unable to query the databaseNo database selected


please what do i do now as i am really worried on how to figure this out.

[robzilla]

It's mysql_num_rows, not mysql_numrows :-)

As for the "No database selected" error, are you establishing a connection to the database anywhere in your script, and selecting a specific database?

[makeithappen]

okay i have done it.


but i still have this error?


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/cashscom/public_html/default.php on line 15

yes am establishing a connection to the database. but the config.php seems to be okay from my end



ERROR



Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/followup/public_html/default.php on line 15

[makeithappen]

new error


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/followup/public_html/default.php on line 15

[robzilla]

What that basically says is that the query result you pass on to mysql_num_rows is invalid.

Try using var_dump() [php.net] to display what the $result variable holds after querying the database.

[makeithappen]

ok let me try it now

[makeithappen]

still getting this error


bool(false)
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/followup/public_html/default.php on line 16

[ergophobe]

I would suggest testing your query in a MySQL client and make sure your query works as expected, and debug from there.

[makeithappen]

am abit of a novice.... please what is the steps in going about this please

[ergophobe]

You can go into PHPMyAdmin on your server and just enter the query and see if it actually works and return what you expect it to return. Then at least you'll know which tree to bark up.

[makeithappen]

yes guys. am fine now. my script is working perfectly

you guys are the best.


Thank you so much ergophobe and robzilla