<th><div class="text-center"></div></th>
<th><div class="text-center">Student Last Name</div></th>
<th><div class="text-center">Student First Name</div></th>
<th><div class="text-center">Intrument</div></th>
<th><div class="text-center">Email</div></th>
<th><div class="text-center">Parent Email</div></th>
<th><div class="text-center">Tuition Due</div></th>
<th><div class="text-center">Tuition Paid</div></th>
<th><div class="text-center">Tuition Owed</div></th>
<th><div class="text-center">Notes</div></th>
';
echo '</tr></thead>';
echo '<tbody>';
//fill in rows with data
while ($row = mysql_fetch_assoc($results)) {
$tmp_payment = get_class_payment('3', $row['class_ref'], $row['student_key']);
$payment = 0;
$payment_dates = "";
while ($rows = mysql_fetch_assoc($tmp_payment)) {
$payment = $payment + $rows['amount_paid'];
}
$payment_due = $row['tuition_due'] - $payment;
echo '<tr>
<td><div class="text-center"><a href="#" onclick="Confirm.render(\'Delete student from class?\',\'delete_student_from_class\',\'', $row['id'], '\')">
<img class="table-icon" src="./res/image/rm-user.png">
</a></div></td>
<td><div class="text-center"><a href="#" onclick="Alert.render(\'Cannot edit students from class tab. Use student tab.\')">
<img class="table-icon" src="./res/image/edit.png"></a></div></td>
<td><div class="text-center">', $row['last_name'], '</div></td>
<td><div class="text-center">', $row['first_name'], '</div></td>
<td><div class="text-center">', $row['instrument'], '</div></td>
<?php
require_once '../init.php';
$link = connectDB();
$results = get_class_payment(3, 1, 1);
$row = mysql_fetch_assoc($results);
var_dump($row);
/*
$results = get_student_list();
echo "here we go";
if(isEmpty($results) {
echo 'could not retrieve';
}
else {
echo 'it isn't empty';
while($row = $results->fetch()){
echo $row['first_name'] . '<br>';
}
}*/
echo 'hi';
