On the table below how would I write a select clause for the SUM of prices for a particular year, say 2013? something like SUM(price WHEN year = 2012). And how would I refer to that result in PHP mysql_fetch_array().
+++++++++++++++++++++++++++++
Price | Date | Month | Year |
+++++++++++++++++++++++++++++
9.00 |343345| 2 | 2013 |
3.00 |343445| 2 | 2013 |
4.00 |343245| 1 | 2013 |
1.00 |342245| 1 | 2013 |
5.00 |333355| 12 | 2012 |
Use an alias:
SELECT SUM(price) AS my_sum
WHERE year = 2102
Then in php:
$row = mysqli_fetch_assoc($result);
echo $row['my_sum'];
SUM(price WHEN year = 2012) - unless I'm mistaken, that's not a valid expressionselect sum(price) from table where year = 2012;
You would refer to it by using:
$data = mysql_fetch_array($query);
echo $data[0];
The query for this will be the below one:
select sum(price) as total_price from your_table_name where Year='2012';
And in PHP you can use it as:
$getTotal = mysql_query("select sum(price) as total_price from your_table_name where Year='2012'");
while($resTotal = mysql_fetch_array($getTotal))
{
$total = $resTotal['total_price'];
}
now you have the total in a variable $total
mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.