Forum PHP.pl

[SQL] pobierz, plaintext 
SET @rowsCount = 0;
SELECT *
FROM (
  SELECT user_id, (
    SELECT SUM( hits )
    FROM pictures
    WHERE owner_id = user_id  
  ) AS hits, @rowsCount := @rowsCount +1 AS rowNumber
  FROM users
  ORDER BY hits DESC
  ) AS tmpTable
WHERE user_id = '232'
[SQL] pobierz, plaintext