RUNNING PROCUREMENT PLAN DETAILS
prepare("SELECT * FROM procplanning"); $result->execute(); for($i=1; $row = $result->fetch(); $i++){ ?>
FINANCIAL.PERIOD OBJECTIVE CODE DETAILS 1ST QTR 2ND QTR 3RD QTR 4TH QTR AMOUNT Action
1ST QTR 2ND QTR 3RD QTR 4TH QTR AMOUNT
Total: prepare("SELECT SUM(FIRSTQTR) FROM procplanning "); $resultas->bindParam(':a', $sdsd); $resultas->execute(); for($i=0; $rowas = $resultas->fetch(); $i++){ $fgfg=$rowas['SUM(FIRSTQTR)']; echo formatMoney($fgfg, true); } ?> prepare("SELECT SUM(SECONDQTR) FROM procplanning"); $resulta->bindParam(':b', $sdsd); $resulta->execute(); for($i=0; $qwe = $resulta->fetch(); $i++){ $asd=$qwe['SUM(SECONDQTR)']; echo formatMoney($asd, true); } ?> prepare("SELECT SUM(THIRDQTR) FROM procplanning"); $resulta->bindParam(':b', $sdsd); $resulta->execute(); for($i=0; $qwe = $resulta->fetch(); $i++){ $asd=$qwe['SUM(THIRDQTR)']; echo formatMoney($asd, true); } ?> prepare("SELECT SUM(FOURTHQTR) FROM procplanning"); $resulta->bindParam(':b', $sdsd); $resulta->execute(); for($i=0; $qwe = $resulta->fetch(); $i++){ $asd=$qwe['SUM(FOURTHQTR)']; echo formatMoney($asd, true); } ?> prepare("SELECT SUM(BUDGETAMOUNT) FROM procplanning"); $resulta->bindParam(':b', $sdsd); $resulta->execute(); for($i=0; $qwe = $resulta->fetch(); $i++){ $asd=$qwe['SUM(BUDGETAMOUNT)']; echo formatMoney($asd, true); } ?>