Stackout
-
Posts
1 -
Joined
-
Last visited
Never
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
MySQL_nuM_rows problem
in PHP Coding Help
Posted
[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.