Forming a request?

Question

PHP

Have a request

set @n = 0;
SELECT
  servers.id,
  servers.game,
  servers.votes,
  @n := @n + 1 AS rank
FROM servers
ORDER BY servers.votes DESC

I need to pull data after this request by id for example id='3'

Answer 1

And why not at once in request?

SELECT *
   from (SELECT  servers.id,
                           servers.game,
                           servers.votes,
                           @n := @n + 1 AS rank
                 FROM servers, (SELECT @n := 0) r
          ORDER BY servers.votes DESC) a 
where id = 3