Adding float values in php

Question

Given the following table:

type   |  valueOfType


food   |  4.3 

food   |  5.3

dairy  |  3.2

food   |  1.3

food   |  6.7

==============

My query needs to search for all "food" type and add all the "valueOfType" where valueOfType is a float type. How can I do it?

edit:

$query = "SELECT SUM(valueOfType) AS Total FROM productTbl WHERE type ='$post_type' ";
$result = mysql_query($query2) 
or die("Unable to execute query because : " .     mysql_error());

echo $result;

Did you try writing DB query and code afterwards?

anubhava
– anubhava

2012-03-07 04:12:31 +00:00
Commented Mar 7, 2012 at 4:12 — anubhava
– anubhava, Commented Mar 7, 2012 at 4:12
use SUM() function as said by judda

Sam Arul Raj T
– Sam Arul Raj T

2012-03-07 04:16:09 +00:00
Commented Mar 7, 2012 at 4:16 — Sam Arul Raj T
– Sam Arul Raj T, Commented Mar 7, 2012 at 4:16

judda · Accepted Answer · 2012-03-07 04:13:19Z

5

SELECT SUM(valueOfType) AS Total FROM foo WHERE type='food'

answered Mar 7, 2012 at 4:13

judda

3,9721 gold badge27 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

DroidMatt Over a year ago

how do I retrieve the answer of the query? Sorry Im very new at PHP. I did exactly, but when I echo-ed the answer, it gave me Resource id #3.

judda Over a year ago

Using the mysql_query or whatever functions you are using to pull information from your database. Tutorial: tizag.com/mysqlTutorial

DroidMatt Over a year ago

hi, sorry to bother you again, can you look at the edited question? I've added the coding. Sorry!

judda Over a year ago

Did you read the tutorial link that I posted? You need to get the data into an array before emitting it. $foo = mysql_fetch_assoc($result); echo $foo['Total'];

DroidMatt Over a year ago

Oh crap, I didn't notice the tutorial part. Sorry, and thanks for the tip!

Collectives™ on Stack Overflow

Adding float values in php

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related