Fixed bug where total number of climbs was not correct

dhoetger · Sep 7, 2015 · debc165 · debc165
1 parent 5f5f4cc
commit debc165
Showing 1 changed file with 1 addition and 1 deletion.
diff --git a/php_dataquery/getWorkoutData.php b/php_dataquery/getWorkoutData.php
@@ -20,7 +20,7 @@ function getNumGyms($db,$userid) {
 
 function getNumClimbs($db,$userid) {
 	//get number of climbs logged
-	$stmt = $db->prepare("SELECT COUNT(reps) FROM workout_segments INNER JOIN workouts ON workouts.workout_id = workout_segments.workout_id WHERE workouts.userid=:userid");
+	$stmt = $db->prepare("SELECT SUM(reps) FROM workout_segments INNER JOIN workouts ON workouts.workout_id = workout_segments.workout_id WHERE workouts.userid=:userid");
 	$stmt->execute(array(':userid'=>$userid));
 
 	$result = $stmt->fetch();