= $current || event_end_date >= $current) AND (group1_id = 15 || group2_id = 15)) order by event_date DESC") //or die("SELECT Error: ".mysqli_error(mysqli $link)) ; if (mysqli_num_rows($result) == 0) { echo "
No Current Announcements
"; } //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']; $event_description = $newArray['event_description']; $notes = $newArray['notes']; $group1_id = $newArray['group1_id']; $group2_id = $newArray['group2_id']; //echo the results on screen echo "";
if ($related_url != "") {
echo " $event_title";
} else {
echo "$event_title";
}
if ($event_description) {
echo "
$event_description";
}
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_location) {
echo "
Location: $event_location";
}
echo "