SQL querry

[Anon]

Please help

I need a count function

If I had a table like this below

id | link | submiter
1 | bla | 1
2 | bla | 2
3 | bla | 1
4 | bla | 3
5 | bla | 2
6 | bla | 2

From the above example
Submiter 1 has added 2
Submiter 2 has added 3
Submiter 3 has added 1

I want to be able to count the table and find the submiter who as added the the most links and the amount he has added.
In the case above it would be submiter 2 with 3

Hope you understand this

Thanks if you can help

Lee

[mattw]

Give this a try:

SELECT submitter,count(*) as count FROM table GROUP BY submitter ORDER BY count DESC LIMIT 1

That should return the highest submitter's id along with the amount he submitted...

Matt Wade
codewalkers.com