--- a/displayCategory.php +++ b/displayCategory.php @@ -1,64 +1,64 @@ -

".$_REQUEST['category']."

"; - $query = 'SELECT "CNID", description, value, "agencyName", category, "contractStart", "supplierName" - FROM contractnotice - WHERE "childCN" is null - AND category = :category - ORDER BY value DESC'; -$query = $conn->prepare($query); -$query->bindParam(":category", $_REQUEST['category']); - $query->execute(); - databaseError($conn->errorInfo()); - - echo " - - - - - - - - - "; - foreach ($query->fetchAll() as $row) { - setlocale(LC_MONETARY, 'en_US'); - $value = number_format(doubleval($row['value']) , 2); - echo (" - - - - - - "); - } - echo "
Contract Notice NumberContract DescriptionTotal Contract ValueAgencyContract Start DateSupplier
{$row['CNID']}{$row['description']}\$$value{$row['agencyName']}{$row['contractStart']}{$row['supplierName']}
"; -} else { - /* - split by main categories - */ - include_header("Categories"); -$query = 'SELECT sum(value), category -FROM contractnotice -WHERE "childCN" is null -GROUP BY category ORDER BY sum(value) DESC '; -$query = $conn->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 "
CategoryTotal Contracts Value
{$row[1]}\$$value
"; -} -include_footer(); +

".$_REQUEST['category']."

"; + $query = 'SELECT "CNID", description, value, "agencyName", category, "contractStart", "supplierName" + FROM contractnotice + WHERE "childCN" is null + AND category = :category + ORDER BY value DESC'; +$query = $conn->prepare($query); +$query->bindParam(":category", $_REQUEST['category']); + $query->execute(); + databaseError($conn->errorInfo()); + + echo " + + + + + + + + + "; + foreach ($query->fetchAll() as $row) { + setlocale(LC_MONETARY, 'en_US'); + $value = number_format(doubleval($row['value']) , 2); + echo (" + + + + + + "); + } + echo "
Contract Notice NumberContract DescriptionTotal Contract ValueAgencyContract Start DateSupplier
{$row['CNID']}{$row['description']}\$$value{$row['agencyName']}{$row['contractStart']}{$row['supplierName']}
"; +} else { + /* + split by main categories + */ + include_header("Categories"); +$query = 'SELECT sum(value), category +FROM contractnotice +WHERE "childCN" is null +GROUP BY category ORDER BY sum(value) DESC '; +$query = $conn->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 "
CategoryTotal Contracts Value
{$row[1]}\$$value
"; +} +include_footer(); ?>