= now() and approved = 'yes' order by eventdate limit 0,5";
$result = mysqli_query($con,$query);
$num_results = mysqli_num_rows($result);
if ($num_results != "0") {
for ($i = 0;$i < $num_results;$i++) {
$row = mysqli_fetch_array($result);
$eventid = $row['id'];
$eventname = htmlspecialchars(stripslashes($row['eventname']));
$eventdate = htmlspecialchars(stripslashes($row['eventdate']));
$contactname = htmlspecialchars(stripslashes($row['contactname']));
$email = htmlspecialchars(stripslashes($row['email']));
$eventdate = strtotime($eventdate);
$eventdate = date('F j, Y', $eventdate);
$starttime = htmlspecialchars(stripslashes($row['starttime']));
$endtime = htmlspecialchars(stripslashes($row['endtime']));
echo '
';
}
}
else {
echo "No current events!";
}
mysqli_close($con);
?>