Get sum of values in database

Asked Apr 01 '13 at 23:16

Active Apr 01 '13 at 23:16

Viewed 67 times

Hi I have searched and tried some right answers in Stackoverflow, but none works.

I tried

$query = "SELECT * FROM Temp";
$query_run = mysql_query($query);
$qty= 0;
While ($num = mysql_fetch_assoc ($query_run)) {
$qty += $num['Price'];
}
echo $qty;

$result = mysql_query('SELECT SUM(Price) AS value_sum FROM Temp');
$row = mysql_fetch_assoc($result);
$sum = $row['value_sum'];

Both saying

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

Could someone help me? Thanks

asked Apr 01 '13 at 23:16

James Chen

Does the table `Temp` exist? Have you tried `var_dump(mysql_error())`? – Niet the Dark Absol Apr 01 '13 at 23:17
5

Welcome to Stack Overflow! [Please, don't use `mysql_*` functions](http://stackoverflow.com/q/12859942/1190388) in new code. They are no longer maintained and are [officially deprecated](https://wiki.php.net/rfc/mysql_deprecation). See the red box? Learn about prepared statements instead, and use [tag:PDO] or [tag:MySQLi]. – hjpotter92 Apr 01 '13 at 23:18
@Kolink yes it does, I even tried 'SELECT SUM(Price) AS value_sum FROM Temp' inside the database, it gives me the right answer – James Chen Apr 01 '13 at 23:18
1

Have you used `mysql_connect` and `mysql_select_db` correctly? – Niet the Dark Absol Apr 01 '13 at 23:19
@Kolink yes, the connection does work. This is just a part of my php code, others are work fine – James Chen Apr 01 '13 at 23:20
try it with fetch_array instead and cast it before doing math actions.. $qty += (int)($num['Price']); – Tony Apr 01 '13 at 23:21
What about the `mysql_error()`? Does it show any error message? – Niet the Dark Absol Apr 01 '13 at 23:22
@dyoser thanks for helping I just tried mysqli instead and it works :-) – James Chen Apr 01 '13 at 23:23
@Kolink thanks for helping I just tried mysqli instead and it works :-) – James Chen Apr 01 '13 at 23:25
@JamesChen Don't tag everyone with same reply. =) – hjpotter92 Apr 01 '13 at 23:27

Get sum of values in database

0 Answers0