Jump to content

Stackout

Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Posts posted by Stackout

  1. 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.
×
×
  • Create New...

Important Information

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.