[Resolved] mysql_num_rows sometimes works :)

[helz]

the tablename has been defined, the query does work but num_rows doesn't 🙁
heres the error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in blahblahblah

$rows = mysql_num_rows(mysql_query("SELECT * FROM $tablename"));

once it works but now it doesnt, i even tried using this:

	$query = "SELECT COUNT(*) AS cnt FROM ".$tablename.""; 
	$result = mysql_query($query); 
	$rows = mysql_result($result,0,"cnt");

but that gives an error also

[stolzyboy]

are you certain the query is working each time?

that is the only reason that mysql_num_rows will barf, is if the query isn't valid, i always try and keep my query, result line, and fetch method separate lines for debugging, here is how i usually would do it:

$query = "select * from '$tablename';";
$result = mysql_query($query) or die(mysql_error());

$num_rows = mysql_num_rows($result);
echo $num_rows;

[helz]

sorry i hate posting errors, silly mistake with me, damn wrong tablename lol

[stolzyboy]

you may hate posting errors, but troubleshooting is the fastest way normally to a solution of your problem