View Full Version : Getting the top / highset 10

02-07-2006, 09:01 AM
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


02-09-2006, 07:50 PM
mysql or mssql ?

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

select * from tablename limit 10

first 10

you can use order by, too

02-10-2006, 05:01 PM
In your database have a count column that increments when people visit the project page.