Re: [PHP] Query question

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.


.

Relevant Pages

  • Re: Exporting wizard truncates value
    ... bunch of junk in it I do not need. ... >Create a query that uses calculated fields to format the ... >Then export the query. ...
    (microsoft.public.access.externaldata)
  • Query question
    ... I have a MySQL database with a date field and a bunch of other fields. ... date field is in the format - 01/01/2006. ... just enter it in the db and then hopefully do the query on it. ...
    (php.general)
  • export from query to tab delimited text file
    ... i want to export to TAB delimited text file from query. ... always include time value even if I set date format to medium date format. ... i want yyyy-mm-dd format so i can import into mysql database and it seems ...
    (microsoft.public.access.queries)
  • Re: function does not return
    ... Some servers will put slashes on returning data, ... The exception to this is if you called addslashes() before you inserted the data in the MySQL database. ... The ifstatement probably made sense years ago, before the query was assigned the line before. ...
    (alt.php)
  • Re: How do mysql_fetch_assoc/mysql_query work?
    ... When I submit a query using PHP I ... at least the data I want) in an array. ... I submit a query to a MySQL database it goes away, ... What language are you using? ...
    (comp.lang.php)