We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

How to sort data from Mysql table by month

richardwalton
on
Medium Priority
551 Views
Last Modified: 2013-12-12
Hello there,

I have created a PHP page that retrieves two columns from a MySQL db (date and amount). What i can't seem to comprehend is the next step... how to sum the amount and show it by month name and year as below.
The Mysql table i have consists of three columns:

-ID Autoincrement
-Date Date
-Minutes Int(11)

This is how i would like to have the data.

January 2001              45673
February 2001            34455
March 2001                23747
April 2001                  86464
May 2001                   6363
June 2001                   0
etc..

Here is my PHP code so far...
----------------------------------
<?php
// connect to the database
include("../include/irm.inc");

$query = "SELECT Date, Minutes FROM tbl_Minutes ORDER BY Date";

$sth = $adb->prepare($query);
if($sth)
{
        $res = $sth->execute();
        $numrows = $sth->rows();
        for($i = 0; $i < $numrows; $i++)
          {
                $result = $sth->fetchrow_hash();
                $Date = $result["Date"];
                $Minutes = $result["Minutes"];
                PRINT "$Date  ";
                PRINT "$Minutes <BR>";
         }
        $sth->finish();
} else
{
    PRINT "Could not prepare query: ".$sth->errstr."<br>\n";
}
?>
------------------------------------------
Any pointers, ideas or examples would be greatly appreciated. Thanks alot.
Richard.
Comment
Watch Question

Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Top Expert 2005
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Top Expert 2005

Commented:
skullnobrains:

Quoting the question (emphasis mine):
>>>What i can't seem to comprehend is the next step... how to SUM THE AMOUNT and show it by month name and year as below.
CERTIFIED EXPERT

Commented:
most sorry snoyes, u were pertinent as usual and i misunderstood the question.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.