Hi,
i know it's a forum for Pawn problems, but it's known for common knowledge, so i'll try it here.
I made a Plugin with Pawn (and that's the clue why i can post it here! xD) and build a website now where you can view some stats etc, i try to start a toplist from X place to X+50 with GET.
PHP Code:
if(!$HTTP_GET_VARS[site])
{
$query="SELECT * FROM `furienmoney` ORDER BY `furienmoney`.`ac_total` DESC LIMIT 50";
}
else
{
$site = $HTTP_GET_VARS[site]; // does'nt work
$site2 = (int)$HTTP_GET_VARS[site]; // does'nt work
$query="SELECT * FROM `furienmoney` ORDER BY `furienmoney`.`ac_total` DESC LIMIT ' . $site2 . ',50";
}
I tried many different ways with ' . $var . ', '$var' etc., nothing worked, i always get:
PHP Code:
Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /usr/www/users/pingst/achievement/players.php on line 64
And when i try to use an integer instead of a variable, it works fine. But i have to use the variable.
Hope someone can help, thx.