/*--------------------------------------------------------------*/ /* Function for Find Activities that are not overdue /*--------------------------------------------------------------*/ function find_activities_overdue($overdue){ global $con; $tday = date('Y-m-d'); // current date $sql = "SELECT *"; $sql .= " FROM activities"; if ($overdue) { $sql .= " WHERE (due_date < $tday)"; } else { $sql .= " WHERE (due_date >= $tday)"; } $sql .= " ORDER BY due_date DESC"; $result = mysqli_query($con,$sql); if($result){ $results = while_loop($result); } else { check_query($result); } return $results; }