--- a/displayConfidentialities.php +++ b/displayConfidentialities.php @@ -10,20 +10,21 @@ */ include_header("Confidentialities"); -$query = "SELECT value, procurementMethod -FROM `contractnotice` -GROUP BY procurementMethod "; +$query = 'SELECT SUM(value) as value, "procurementMethod" +FROM contractnotice +GROUP BY "procurementMethod" '; -$result = mysql_query($query); + $query = $conn->prepare($query); + $query->execute(); + databaseError($conn->errorInfo()); echo "
{$row[1]} | \$$value |