PHP Sum Of Mysql row value

Question

figure 1. sum all value of money id date name money //sample items only 1 March 5 2014 matt 50 //records to add 2 March 5 2014 john 10 //records to add 3 March 2 2014 matt 50 //records to add figure 2. sum all value of money when search matt id date name money //sample items only 1 March 5 2014 matt 50 //records to add 2 March 5 2014 john 10 3 March 2 2014 matt 50 //records to add

Hi guys can you help me i dont know the code how to Add the rows value in my sql database.(see sample above)

i have this code which will count how many records i have

<input type="text" name="namesearch" size="5" tabindex="1" /> <input type="submit" name='click' value='Search' /> if(isset($_POST['click'])){ $name= $_POST['namesearch']; $query = "SELECT COUNT(*) AS total FROM table WHERE name='$name'"; $result = mysql_query($query); $values = mysql_fetch_assoc($result); $num_item= $values['total']; echo "Number of Records Found # ".$num_item;

what you tried in your query?

Zeeshan
– Zeeshan

2014-03-05 06:47:33 +00:00
Commented Mar 5, 2014 at 6:47 — Zeeshan
– Zeeshan, Commented Mar 5, 2014 at 6:47
mysql_num_rows($result)

SajithNair
– SajithNair

2014-03-05 06:51:35 +00:00
Commented Mar 5, 2014 at 6:51 — SajithNair
– SajithNair, Commented Mar 5, 2014 at 6:51

Firman Hidayat · Accepted Answer · 2014-03-05 06:52:49Z

use this as query

$query = "SELECT COUNT(*) AS total, SUM(money) AS total_money FROM table WHERE name='$name'";

use this to view the result

$num_item = $values['total']; $total_value = $values['total_money']; echo "Number of Records Found # ".$num_item; echo "Total Money ".$total_value

Sniffleh · Accepted Answer · 2014-03-05 06:52:44Z

Since my MySQL server is missing after an OS upgrade, don't trust the syntax (lol). Try this:

SELECT COUNT(*), SUM(`money`) AS `total_money` FROM `my_table` GROUP BY `name`;

This should(?) give you the count of rows for each name and it's sum of total money.

Tau · Accepted Answer · 2014-03-05 06:56:50Z

0

Use MySQL SUM Function

SELECT SUM(money) AS total FROM table WHERE name='$name'

answered Mar 5, 2014 at 6:56

Tau

4683 silver badges14 bronze badges

Collectives™ on Stack Overflow

PHP Sum Of Mysql row value

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related