Getting the top / highset 10

[tamiya]

How would i go about getting the top 10 entries for a certain month?
eg. there are a hundred projects in my database (msql) and i would like to see which 10 were viewed the most during the last month...

any help would be appreciated

thx

[IeD3vil]

mysql or mssql ?

doesnt matter, it`s the same syntax here...

select * from tablename limit 10

first 10

you can use order by, too

[Pixelcode]

In your database have a count column that increments when people visit the project page.