mysql user variables

[dertyfern]

Having a problem getting a counter working in mysql 6.x. Here's my sql stmt:

set @counter=0;
SELECT (@counter:=@counter+1) FROM calendar.tbl limit 10;

I get 'null' values. Any idea why this doens't work?

Thanks

[dertyfern]

Anyone got anything on this?