faqts : Computers : Programming : Languages : PHP

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

7 of 15 people (47%) answered Yes
Recently 4 of 10 people (40%) answered Yes

Entry

How can I sort data out of my MYSQL database in monthly Stats format and display it in an html page?

Feb 29th, 2008 09:46
dman, John Marc, Ronald Sprinkel, http://www.ttnr.org


select monthname(date) as month,sum(qty) from datafile group by 1