[Geraldm]

Hi,

Thanks, that works, although I had to modify it like so:
[sql]SELECT count(*) as 'total' from post
where dateline between UNIX_TIMESTAMP('2007-04-17 00:00:00')
and UNIX_TIMESTAMP('2007-06-18 23:59:59')
group by userid order by total desc limit 10;
[/sql]

But it only outputs on column called total .... how do I also display the userid ??

Cheers ....
Gerald.

Originally Posted by Eikinskjaldi

[sql]
select userid, count(*) as 'total' from post
where dateline between (unix_timestamp('2007-04-17'), unix_timestamp('2007-06-18'))
group by userid order by total desc limit 10;
[/sql]