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. Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/4890-mysql_num_rows-problem/#findComment-17211 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.