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@xxxxxxxxx> 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
