[SOLVED] Strange MySQL Error that wasnt there before.

[Woodsyx]

Hey just wondering if I could get some help with this error. I had the exact same lines of code up to that point in a previous file with no problems and all of a sudden this is showing up.

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ///// on line 51

 

 

$result = mysql_query("SELECT lasttime FROM idlers WHERE name='".mysql_real_escape_string($name)."'");
		$row = mysql_fetch_array($result);
		$ptime = $row['lasttime'];

 

[MadTechie]

i would say update the line to

 

$result = mysql_query("SELECT lasttime FROM idlers WHERE name='".mysql_real_escape_string($name)."'") or die(mysql_error());

to display the error

 

but your code doesn't contain the line with the error !

mysql_num_rows() isn't in that code!

[Woodsyx]

Oh whoops I copy pasted the wrong lines of code here is line 50-51

 

$value = mysql_query("SELECT name FROM idlers WHERE name='".mysql_real_escape_string($name)."' LIMIT 1");
		$num_rows = mysql_num_rows($value); 

[MadTechie]

add or die(mysql_error());

 

$value = mysql_query("SELECT name FROM idlers WHERE name='".mysql_real_escape_string($name)."' LIMIT 1") or die(mysql_error());

[Woodsyx]

Well that was simple turn out I had "" instead of '' around my table var. Thanks for the help and I'll remember to add that bit of code on any problem mysql stuff next time.