include('dbconnect.php');
// Retrieve all the data from the "figure8" table
$today = date("Y-m-d");
//die("Today = " . $today);
$query = "SELECT *";
$query .= " FROM upcoming_events";
$query .= " WHERE proj_date >= '". $today . "'";
$query .= " ORDER BY proj_date, proj_time ASC";
//die($query);
//echo "
";
$sqlresult = mysqli_query($con,$query) or die(mysqli_error($con));
$RecordCount = mysqli_num_rows($sqlresult);
?>
Upcoming Events |
if($RecordCount > 0){
while($row = mysqli_fetch_array($sqlresult)){
$evntDate = date('D M j, Y', strtotime($row['proj_date']));
echo "";
echo " " . $evntDate . " " . date('h:i a' , strtotime($row['proj_time'])). " | ";
echo " ";
echo "" . $row['proj_title'] . " ";
echo $row['proj_desc'];
echo " | ";
echo "
";
echo "
|
";
}
}else{
echo "| No Records in event Table at this time! |
";
}
?>