query("SELECT * FROM user_table WHERE authorizationrights = 'GRANTED' ")) { while ($row = $result->fetch_assoc() ) { $stdd=$stdd. ""; } } $connect->close(); ?> proc
Procurement planning
Running procurement plan by financial period
prepare("SELECT FINANCIALPERIOD, SUM(BUDGETAMOUNT), SUM(TOTALROB) FROM procplanning GROUP BY FINANCIALPERIOD DESC"); $result->execute(); for($i=1; $row = $result->fetch(); $i++){ ?>
FINANCIAL PERIOD TOTAL AMOUNT PLANNED BALANCE REMAINING
TOTAL: prepare("SELECT SUM(BUDGETAMOUNT) FROM procplanning "); $resultas->bindParam(':a', $sdsd); $resultas->execute(); for($i=0; $rowas = $resultas->fetch(); $i++){ $fgfg=$rowas['SUM(BUDGETAMOUNT)']; echo formatMoney($fgfg, true); } ?> prepare("SELECT SUM(TOTALROB) FROM procplanning"); $resulta->bindParam(':b', $sdsd); $resulta->execute(); for($i=0; $qwe = $resulta->fetch(); $i++){ $asd=$qwe['SUM(TOTALROB)']; echo formatMoney($asd, true); } ?>