Query help for Select

[balaraju mandala]

Hi All,
I need help in this  procedure, i am limiting the result to single row by
using 'limit' in select statement. But i am using a variable here, mysql is
throwing error as i am using variable, please give some suggestions.

create procedure  Report_login_Activity2()
begin
declare count,i int DEFAULT 0;
set i = 0;
select count(*) into count from playersloginfo;
while(i <= count) do
select user_name, concat(logindate, ' ', logintime), concat(logoutdate, ' ',
logouttime), TIMEDIFF(concat(logoutdate,' ', logouttime), concat(logindate,'
', logintime)) from playersloginfo *limit i,1;*
end while;
end;