Adding a "position" number in Mysql
SET @x = 0;
SELECT (@x:=@x+1) Pos,* FROM
(
    SELECT songname,COUNT(*) as count FROM etrstats
    WHERE songname != '' AND `when` &gt;= DATE_SUB(CURRENT_DATE, INTERVAL 1 MONTH)
    GROUP BY songname ORDER BY count DESC LIMIT 5
) A;


Give it a Try !!!

I do incrementing of temp variables in other posts


Jun 08, 2012 : Update rank on a large table
Jun 03, 2013 : Embedded select with rank