Mysql count threads

[guest]

Im working on an antileech script and i found a simple command to see if the same ip is connected 2 or more time, then it would stop. But it doesnt seem to work for some reason 😕

heres the script

$ip = $_SERVER['REMOTE_ADDR'];
$Query = "SELECT SUM(threads) FROM connected WHERE ip = '".$ip."'";
$Result = mysql_query($Query);
if ($Result >= 2)
		{
        print('No more than 2 connection from the same IP at a time');
		exit;
		}

what its supposed to do is add up the selected tables that have the same ip and if its more or equal to 2 then it would print the about and close the script.

It doesnt seem to be workign and theres no error message to i was wondering if one of you could see why the script isnt working properly

[robert_w_ark]

I was recently surfing the internet to find this code. Maybe it will help..

$query = "SELECT SUM(threads) FROM ".$MAIN['db_table']." WHERE ip = '".$ip."'";
$result = mysql_query($query);
if(mysql_num_rows($result)) $threads = mysql_num_rows($result);
else $threads = 0;

[guest]

im getting this stupid error 🙁

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/surfer/public_html/dl/dl1.php on line 22

heres my script

// connect to the mysql server
$con = @mysql_connect("", "", "");
if (!$con)
{
print("unable to connect to database");
exit();
}
else
{
mysql_select_db("");
}




$ip = $_SERVER['REMOTE_ADDR'];

$query = "SELECT SUM(threads) FROM table WHERE ip = '".$ip."'";
$result = mysql_query($query);
if(mysql_num_rows($result))
    {
$threads = mysql_num_rows($result);
    } else {$threads = 0;}

[Drakla]

Are you really selecting a database with no name, or is that just a quick copy out your code error?

[bradgrafelman]

You might also want to take a look at the Debugging 101 thread (link in my sig) if you did indeed remove the actual DB name as Drakla mentioned.