--- a/displayCalendar.php +++ b/displayCalendar.php @@ -1,15 +1,38 @@

".$_REQUEST['category']."

"; + $query = "SELECT CNID, description, value, agencyName, category, contractStart, supplierName + FROM `contractnotice` + WHERE childCN = 0 + AND category = '" . $_REQUEST['category'] . "' + ORDER BY value DESC"; + $result = mysql_query($query); + echo ""; + while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { + setlocale(LC_MONETARY, 'en_US'); + $value = number_format(doubleval($row['value']) , 2); + echo (" + + + + + + "); + } + echo "
{$row['CNID']}{$row['description']}\$$value{$row['agencyName']}{$row['contractStart']}{$row['supplierName']}
"; + mysql_free_result($result); +} else { /* split by year - */ -/* todo: Year/Month drilldown - largest contracts, agencies, suppliers big picture graphs?*/ -include_header("Months and Years"); $query = "SELECT YEAR(contractStart), MONTH(contractStart), value FROM `contractnotice` WHERE childCN = 0 GROUP BY MONTH(contractStart), YEAR(contractStart) ORDER BY YEAR(contractStart), MONTH(contractStart) "; @@ -23,6 +46,6 @@ } echo ""; mysql_free_result($result); - +} include_footer(); ?>