PDA

View Full Version : Getting the top / highset 10



tamiya
02-07-2006, 08: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

thx

IeD3vil
02-09-2006, 06: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

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