[teksigns]

here is a example database.

i have a table named

color_guide

with the following fields and data.

-------------------------------------------------
| poster | color | info | more info |
-------------------------------------------------
| john | blue | xx | xx |
| joe | black | xx | xx |
| chris | red | xx | xx |
| john | yellow | xx | xx |
| joe | xxxx | xx | xx |
| john | xxxx | xx | xx |
-------------------------------------------------

so in my sample database i need a query that will
check who has the most rows and display the count .

example :

John has 3 post