Welcome to WebmasterWorld Guest from 54.163.40.152

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Adding together variables form an SQL select statement

     

ModernMerlin

9:00 am on Jun 7, 2012 (gmt 0)



What I am trying to do and for some reason am drawing a blank, is figure out how to pull several numbers from the same column in a table and add them together to get one final number for another math problem.

For example:
$query = mysql_query ("SELECT attr_amt FROM user_attr WHERE user_id = '".$user_id."'") or die(mysql_error());

And then I assume I would add a foreach but for some reason cannot for the life of me figure out how to add the numbers together. Perhaps its because its 2am lol.

For example lets say there are three entries in the table for that user.

Any ideas/suggestions/guidance would be greatly appreciated!

Thanks!

rlange

2:31 pm on Jun 7, 2012 (gmt 0)



It sounds like you want to use MySQL's SUM() function.

$result = mysql_query( "SELECT SUM( `attr_amt` ) AS `total` FROM `user_attr` WHERE `user_id` = '" . $user_id . "'" ) or die( mysql_error() );

echo $result['total'];


Other, non-essential changes in the above code:
  • Whitespace: The extra whitespace is just my personal coding convention.
  • Backticks (`): Using backticks around column and table names lets you use otherwise reserved keywords (e.g. `count`) or spaces and other characters (e.g. `dont do this` and `just,dont`). They're MySQL-specific, though.

ModernMerlin

3:23 am on Jun 9, 2012 (gmt 0)



That is exactly what I was looking for. Thank you so much!
 

Featured Threads

Hot Threads This Week

Hot Threads This Month