query("SELECT assign_no, topic, assignment_type FROM assignments WHERE id IN (SELECT assign_id FROM course_assign_user_auth WHERE user_id = '" . $_SESSION['user_id'] . "' AND auth_status = '2' AND assign_id IN (SELECT id FROM assignments WHERE course_id = '" . $_GET['id'] . "'))");
while ($total_auth_assignments_row = $total_auth_assignments_result->fetch_array()) {
$temp_result = $db->query("SELECT id FROM upload_assignments WHERE assign_no = '" . $total_auth_assignments_row['assign_no'] . "' AND user_id = '" . $_SESSION['user_id'] . "' AND course_id = '" . $_GET['id'] . "' AND status <> '7' ");
$submitted_row = $temp_result->fetch_array();
if (!$submitted_row) {
$pending_assignments[] = $total_auth_assignments_row;
}
}
// Check if non-submitted pending assignments are there
if (count($pending_assignments) == 0) {
echo 'You don\'t have any pending assignments at the moment';
exit;
}
?>