= $current || event_end_date >= $current) AND (group1_id = 15 || group2_id = 15)) order by event_date ASC")
or die("SELECT Error: ".mysqli_error($link));
if (mysqli_num_rows($result) == 0) {
echo "No Upcoming Events
";
}
//display the data
while ($newArray = mysqli_fetch_array($result)) {
$event_type = $newArray['event_type'];
$event_date = $newArray['event_date'];
$event_time = $newArray['event_time'];
$event_time_ap = $newArray['event_time_ap'];
$event_end_date = $newArray['event_end_date'];
$event_location = $newArray['event_location'];
$event_title = $newArray['event_title'];
$event_speaker = $newArray['event_speaker'];
$speaker_afil = $newArray['speaker_afil'];
$related_url = $newArray['related_url'];
$abstract_name = $newArray['abstract_name'];
//echo the results on screen
echo "";
if ($related_url != "") {
echo "- $event_title";
} else {
echo "
- $event_title";
}
if (strlen($event_date) == 8) {
$yearstart = substr($event_date, 0, 4);
$monthstart = substr($event_date, 4, 2);
$daystart = substr($event_date, 6, 2);
}
echo "
$monthstart.$daystart.$yearstart";
if (strlen($event_end_date) == 8) {
$yearend = substr($event_end_date, 0, 4);
$monthend = substr($event_end_date, 4, 2);
$dayend = substr($event_end_date, 6, 2);
}
if ($event_type != "announcement") {
echo " to $monthend.$dayend.$yearend";
}
if ($event_location) {
echo "
Location: $event_location";
}
echo "
";
}
?>