foreach ($ro3->personalBalancePatient_registrationNo() as $registrationNo) { ?> <tr> <td> <?php echo $ro4->formatDate($ro3->selectNow("registrationDetails", "dateUnregistered", "registrationNo", $registrationNo)); ?> </td> <td> <?php echo $ro3->selectNow("patientRecord", "lastName", "patientNo", $ro3->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo)) . ", " . $ro3->selectNow("patientRecord", "firstName", "patientNo", $ro3->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo)); ?> </td> <td> <?php $personalBalance += $ro3->personalBalancePatient_total($registrationNo) + $ro3->personalBalancePatient_therapy_total($registrationNo); echo number_format($ro3->personalBalancePatient_total($registrationNo) + $ro3->personalBalancePatient_therapy_total($registrationNo), 2); ?> </td> </tr> <?php } ?> </tbody> <tbody> <tr> <td> </td> <td> </td> <td><?php echo number_format($personalBalance, 2); ?>