Czy ktoś mi powie dlaczego:

[PHP] pobierz, plaintext 
$querya = mysql_query("set @id=$id,@nr = 0, @idnr = 0;
select @idnr as nr from (SELECT @nr:=@nr+1,if(ID=@id, @idnr :=
@nr,@idnr=@idnr),ID FROM `users` order by `points` DESC)
podsel where podsel.`id` = @id;") or die (mysql_error());
[PHP] pobierz, plaintext 

zwraca błąd:

[SQL] pobierz, plaintext 
You have an error IN your SQL syntax; CHECK the manual that corresponds TO your MySQL server version FOR the RIGHT syntax TO USE near 'select @idnr as nr from (SELECT @nr:=@nr+1,if(ID=@id, @idnr := @nr,@idnr=@idn' at line 2
[SQL] pobierz, plaintext 

a jak wkleje to zapytanie w PhpMyAdminie w oknie SQL to wszystko ładnie przechodzi?

Tam są dwa zapytania:

[SQL] pobierz, plaintext 
SET @id=$id,@nr = 0, @idnr = 0;
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT @idnr AS nr FROM (SELECT @nr:=@nr+1,IF(ID=@id, @idnr :=
@nr,@idnr=@idnr),ID FROM `users` ORDER BY `points` DESC)
podsel WHERE podsel.`id` = @id;
[SQL] pobierz, plaintext 

Kazde masz wykonac w oddzielnym mysql_query()