?>
<?php
while ($row = mysql_fetch_assoc($results)) {
$idc_id = $row['id'];
$contractor = $row['contractor'];
$year = $row['year'];
$quarter = $row['quarter'];
$idc_type = $row['idc_type'];
$scope = $row['scope_of_work'];
$award = $row['award_Amount'];
$sum = $row['sum_all_dos'];
$contract = $row['contract_balance'];
$totals = get_do_totals($idc_id);
$current = $award - $totals;
$total_reimbursed = get_do_reimbursements($idc_id);
$commencement = $row['commencement'];
$expiration = $row['expiration'];
?>
<table id="idc_table">
<tr>
<td>Contractor:</td>
<td><?php
echo $contractor;
?>
</td>
</tr>
<tr>
<td>Quarter </td>
{
$query2 = "SELECT * FROM tbl_dos WHERE idc_id = '{$idc}'";
$results2 = mysql_query($query2) or die(mysql_error());
#$array = mysql_fetch_array($results2, MYSQL_NUM);
$counter = 0;
$counter2 = 0;
while ($row2 = mysql_fetch_assoc($results2)) {
$counter += $row2['basic'];
$counter += $row2['additional'];
// echo $row2['basic'];
//echo $row2['additional'];
}
return $counter;
}
function get_do_reimbursements($idc)
{
$query2 = "SELECT * FROM tbl_dos WHERE idc_id = '{$idc}'";
$results2 = mysql_query($query2) or die(mysql_error());
#$array = mysql_fetch_array($results2, MYSQL_NUM);
$counter = 0;
$counter2 = 0;
while ($row2 = mysql_fetch_assoc($results2)) {
$counter += $row2['reimbursed'];
// echo $row2['basic'];
//echo $row2['additional'];
}
return $counter;
}
echo get_do_totals(12);
echo get_do_reimbursements(12);
