need help counting rows

[wil831]

i have an int type column in one of my tabes that stores the relation id from another table.

the values are something like

column5

3
4
4
3
7
2
4

i need to store the highest number of like entries to $high. so for the example above $high=4 since '4' has the most entries; how would i do this?

[barand]

SELECT column5, count(*) as count FROM tablename
GROUP BY column5 ORDER by count DESC LIMIT 1

the row in the result set will contain the value of column5 with highest count.

hth