MySQL - Get row number on select

http://stackoverflow.com/questions/2520357/mysql-get-row-number-on-select

SET @rank=0;
SELECT @rank:=@rank+1 AS rank, itemID, COUNT(*) as ordercount
  FROM orders
  GROUP BY itemID
  ORDER BY ordercount DESC;