Use the mysql list :)

On Oct 28, 2006, at 3:01 PM, Beauford wrote:

Hi,

I have a MySQL database with a date field and a bunch of other fields. The date field is in the format - 01/01/2006. What I want to do is query the database and create a table that shows just the year and how many instances of the year there is. I have been taxing my brain for a simple solution, but
just not getting it. Any suggestions?

Thanks

Example output.

Year    Count

2002    5
2003    8
2004    9
2005    15
2006    22

ps - I get this information sent to me and I can't change any of the data. I
just enter it in the db and then hopefully do the query on it.



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to