prepare('SELECT `group` FROM `events` WHERE `group` LIKE \'%.%\' GROUP BY `group` ORDER BY `group` DESC'); $stmt->execute(); $groups = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($groups as $g) { $group = $g['group']; $stmt = $pdo->prepare('SELECT * FROM `events` WHERE DATE_ADD(`start`, INTERVAL `duration` MINUTE) > UTC_TIMESTAMP AND `group` = :group ORDER BY `start` ASC'); $stmt->bindParam(':group', $group); $stmt->execute(); $events = $stmt->fetchAll(PDO::FETCH_ASSOC); // Header echo "
"; // Events foreach ($events as $e) { $id = $e['eventID']; $title = $e['title']; $desc = $e['description']; $link = $e['link']; $start = new DateTime($e['start']); $date = str_replace('-', '/', $e['start']); $code = $start->format('md'); $slot = $start->format('M d, h A'); if (strlen($desc) == 0) $desc = " "; echo "
$desc
$slot Register
"; } echo "
"; } ?> prepare('SELECT `eventID`,`title`,`host`,`description`,`start`,`duration`,`link`,`group` FROM `events` WHERE `group` NOT LIKE \'%.%\' AND DATE_ADD(`start`, INTERVAL `duration` MINUTE) > UTC_TIMESTAMP GROUP BY IFNULL(`group`, `eventID`) ORDER BY `start`,`eventID` ASC'); $stmt->execute(); $events = $stmt->fetchAll(PDO::FETCH_ASSOC); $stmt->closeCursor(); if (count($groups) < 1 && count($events) < 1) { ?>

There are no scheduled events.

modify('+' . $g['duration'] . ' minutes'); $grouped = strlen($g['group']) > 0; ?>

to -

prepare('SELECT `eventID`,`host`,`start`,`duration`,`link` FROM `events` WHERE DATE_ADD(`start`, INTERVAL `duration` MINUTE) > UTC_TIMESTAMP AND `group` = :group ORDER BY `start` ASC'); $stmt->bindParam(':group', $g['group']); $stmt->execute(); $times = $stmt->fetchAll(); ?>modify('+' . $t['duration'] . ' minutes'); $o_start = str_replace('-', '/', $t_start->format('Y/m/d H:i:s')); $o_end = str_replace('-', '/', $t_end->format('Y/m/d H:i:s')); ?>
Register