Msg#: 4462361 posted 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!
Msg#: 4462361 posted 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() );
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.