--- a/displayProcurementMethod.php +++ b/displayProcurementMethod.php @@ -1,31 +1,33 @@ -"; -while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { -setlocale(LC_MONETARY, 'en_US'); -$value = number_format(doubleval($row[0]),2); - echo ("{$row[1]}\$$value"); -} -echo ""; -mysql_free_result($result); -include_footer(); -?> - - +prepare($query); + $query->execute(); + databaseError($conn->errorInfo()); + +echo ""; + foreach ($query->fetchAll() as $row) { +setlocale(LC_MONETARY, 'en_US'); +$value = number_format(doubleval($row[0]),2); + echo (""); +} +echo "
{$row[1]}\$$value
"; +include_footer(); +?> + + +