Re: Query question

Agreed, this should go to a MySQL list. But in the spirit of helping I think the following should give you a good starting point. SELECT year, COUNT(year) AS count FROM tbl GROUP BY year ASC On 10/28/06, Ed Lazor <edlazor@yahoo.com> wrote:

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