Problem with Sum
Posted: Mon Nov 05, 2007 4:13 am
Hey there,
When I run this query
I get back
How do I access the value, I tried echo $qscore[sum(`questionScore`)] ; but it does not like the sum function..
Any Ideas,
Chris
When I run this query
Code: Select all
$numofQuestions = count($assessmentNames);
$query = "SELECT sum(`questionScore`) FROM `results` WHERE `sessionID`='".$_SESSION['sessionID']."'";
$result = $this->dbh->query($query);
$qscore = $result->fetch(PDO::FETCH_ASSOC);
print_r($qscore);Code: Select all
Array ( [sum(`questionScore`)] => 300 )Any Ideas,
Chris