query( $sql );
if ( $result->num_rows > 0 ) {
// output data of each row
while ( $row = $result->fetch_assoc() ) {
$content = $row[ 'news_content' ];
$id = $row[ 'id' ];
$news_name = $row['news_name'];
}
} else {
echo "0 results";
}
if($news_month == '01'){
$news_month = "January";
}
elseif($news_month == '02'){
$news_month = "Febuary";
}
elseif($news_month == '03'){
$news_month = "March";
}
elseif($news_month == '04'){
$news_month = "Aprial";
}
elseif($news_month == '05'){
$news_month = "May";
}
elseif($news_month == '06'){
$news_month = "June";
}
elseif($news_month == '07'){
$news_month = "July";
}
elseif($news_month == '08'){
$news_month = "August";
}
elseif($news_month == '09'){
$news_month = "September";
}
elseif($news_month == '10'){
$news_month = "October";
}
elseif($news_month == '11'){
$news_month = "November";
}
elseif($news_month == '12'){
$news_month = "December";
}
//Create the count down
$date = strtotime("$event_month $event_day, $event_year $start_time");
$remaining = $date - time();
$days_remaining = floor($remaining/60/60/24);
$hours_remaining = floor(($remaining-($days_remaining*60*60*24))/60/60);
$min_remaining = floor(($remaining-($days_remaining*60*60*24)-($hours_remaining*60*60))/60);
$seconds_remaining = floor((($remaining-($days_remaining*60*60*24)-($hours_remaining*60*60))-($minutes_remaining*60))/120);
$sql = "SELECT *FROM events";
$result = $conn->query( $sql );
if ( $result->num_rows > 0 ) {
// output data of each row
while ( $row = $result->fetch_assoc() ) {
$side_bar_events .= " ".$row[ 'event_name' ]."".$row[ 'event_month' ]."";
}
} else {
echo "0 results";
}
$conn->close();
?>
