[Resolved] mysql_num_rows

[NeoGeo]

Ok, this is rather strange to me... i've used this function many times but its tripped me up real good this time.

Here's my code:

function ShowTables() {

$return = true;

$result = mysql_query("show tables");

if(mysql_num_rows($result) == 0) {
	$return = false;
}

return $return;

}

if I run this function I get this error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/hiddensp/public_html/dev/api/func_database.php on line 64

I've determined that no matter what I use in the mysql_query argument (no matter how valid - especially since 'show tables' is as simple and valid as queries get) that it still doesn't return a valid mysql resource...

So I guess my question is what should I be checking now? I know it is connecting to the database (there would be database connection errors on the page if that wasn't the case). I know that it is including the func_database.php file (because it references the line where the function is located). I know that I have permission to run this query (Using the same user I run this query from phpMyAdmin).

What else should I be checking that would cause this error?

Appreciate any help it really sucks being hung up for an hour an such something soooo stupid.

Thanks,
Ben

[laserlight]

This is what I might use when debugging, with error_reporting set to E_ALL

function ShowTables() {
	$return = true;

if ($result = mysql_query("SHOW TABLES")) {
	if (mysql_num_rows($result) == 0) {
		$return = false;
	}
} else {
	die(mysql_error()); //for debugging
}

return $return;
}

This is what I might use in practice:

function ShowTables() {
	$return = true;

if ($result = @mysql_query("SHOW TABLES")) {
	if (@mysql_num_rows($result) == 0) {
		$return = false;
	}
} else {
	$return = false;
}

return $return;
}

[NeoGeo]

I noticed that none of my functions in the func_database file are working... does it have to do with my file structure?

The page, lets call it page.php has an include statement:

include("../func_base.php");

which contains two lines:

include("func_database.php");
include("func_validation.php");

now, if I run a file from the same directory as func_base.php, then my include in that page is:

include("func_base.php");

and everything works fine... from a page outside the directory and using:

include("../func_base.php");

not fine. But the functions in func_database.php are being called, and the query that is being used by mysql_query() is a valid query - but it just returns and invalid mysql resource every time... ????

Is there some lame rule here I don't know about and is there a way around it or what?

Thanks for your time,
Ben

[NeoGeo]

Ok, looks like it was a connection problem, my error checking for my connection was working on the page in the same directory as func_base.php but not in the same page as the page in the different directory.

So looks like there wasn't any lame rule - just a lame developer :bemused:

Thanks for your help though!

Ben