--- a/displayConsultancies.php +++ b/displayConsultancies.php @@ -14,16 +14,18 @@ FROM `contractnotice` GROUP BY procurementMethod "; -$result = mysql_query($query); + + $query = $conn->prepare($query); + $query->execute(); + databaseError($conn->errorInfo()); echo "
{$row[1]} | \$$value |