Stackout Posted March 14, 2006 Share Posted March 14, 2006 Hey, I've got a question. Why do I get the error[i]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\WEBS\webdirectory\online.php on line 38[/i]Some odd reason I just don't see the problem. Coudl someone point me to what is wrong? Here is the code:[code]$sql = mysql_query("SELECT * FROM ".$sql_prefix."users_online WHERE country = '".ip2country($ip)."'",$conn);if(mysql_num_rows($sql) > 0){ $select_tes_lgi = mysql_query("SELECT * FROM ".$sql_prefix."visits WHERE ip = '".$ip."' LIMIT 1",$conn); if(mysql_num_rows($select_tes_lgi) != 0){ $sel = dosql($sql,1); $hit_add = (($sel[0][2]) + (1)); mysql_query("UPDATE ".$sql_prefix."visits_status SET hits = '".$hit_add."' WHERE country = '".ip2country($ip)."'"); }}else{ mysql_query("INSERT INTO ".$sql_prefix."visits_status (hits,country) VALUES ('1','".ip2country($ip)."')");}[/code]I just don't see the problem. Thanks if someone could help. Link to comment https://forums.phpfreaks.com/topic/4890-mysql_num_rows-problem/ Share on other sites More sharing options...
Steveo31 Posted March 14, 2006 Share Posted March 14, 2006 Try adding "or die(mysql_error())" to the query it is referring to. If the rows arguement is throwing a fit, it's usually becuase the query isn't correct. Link to comment https://forums.phpfreaks.com/topic/4890-mysql_num_rows-problem/#findComment-17211 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.