help with Database searching

europhreak · February 7th, 2006, 11:31 PM

i have a table in a database that saves search activity, it has the following 3 columns:

search_ID (autonumber)
State (text)
Language (text)

what i want to be able to do is create a page that will display the number of searches/filters based on a language. here's what the output would look like:

Count Language
-----------------------
25 English
18 Spanish
14 Russian

so if only those languages were searched there would be only 3 rows, however if more languages would be searched more rows would show up. how would the sql look like??

ChrisScott · February 8th, 2006, 07:30 AM

Code:

SELECT COUNT(*) AS searchCount, language 
FROM yourTableName
GROUP BY language
ORDER BY COUNT(*) DESC;

HTH,

Chris