I need to get the figures for the last six months from my orders table. The table has the following fields: qty, product, price, code,

The format of the report must be as follows:

Month:   Jan Feb Mar Apr May June

Product1  7   5   4   6   8  9
Product2  8   3   1   4   7  7
Product3  5   4   1   7   7  6

My current code gets the figures for one month only:

    "SELECT product,building, SUM(qty) AS 'month1' FROM sh_orders WHERE MONTH(order_date) = MONTH(CURDATE())  GROUP BY product";

The code to show it is:

    echo "
    <td> ". $row['product']. "</td>
    <td> ". $row['month1']. "</td>;

Any help is greatly appreciated.