?> <?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);