Custom Query Help

I saw this query about adding rownumbers from here:

http://www.asprunner.com/forums/topic/20596-display-row-line-number-master-or-detail-lists/
Iv tryed to get this to work by edit sql query and using this:

select @rownum:=@rownum+1 'rank', p.* from player p, (SELECT @rownum:=0) r order by score desc limit 10;
What i need is to implement this solution to this original query but i cant get it to work:
SELECT

sekretariatID,

owner,

tnr,

sport,

tnamn,

klass,

gren,

typ,

rank,

nr,

namn,

fodd,

klubb,

r1,

f1,

r2,

f2,

r3,

f3,

r4,

f4,

r5,

f5,

r6,

f6,

anm,

flagga1,

flagga2,

kostnad,

sign

FROM sekretariat
Pls advice.
Regards