set @row:=0;SELECt @row:=@row+1 as row_numer, NAME, SUM(donationvalue) as total FROM tbl_pdm2k10_DonationsGROUP BY NAMEORDER BY total desc

set @row:=0;SELECt @row:=@row+1 as row_numer, NAME, SUM(donationvalue) as total FROM tbl_pdm2k10_DonationsGROUP BY NAMEORDER BY total desc