| "; $now = date("Y-m-d"); $mysqli = new mysqli ("localhost", "burwelllive_blmii", "Jerem!ah2911", "burwelllive_website") or die ('I cannot connect to the database because: ' . mysql_error()); $uresult = $mysqli->query("SELECT * FROM Calendar WHERE (Drop_Date < '$now' && Title not like '%NO SALE%') ORDER BY Date DESC", MYSQLI_USE_RESULT); if ($uresult) { while ($data = $uresult->fetch_assoc()) { $Event_ID = $data["Event_ID"]; $Event_time = $data["Event_time"]; $Title = $data["Title"]; $Location = $data["Location"]; $Description = $data["Description"]; $Event_day = $data["Event_day"]; $Date = $data["Date"]; $Drop_Date = $data["Drop_Date"]; $Event_preview = $data["Event_preview"]; $Summary = $data["Summary"]; $Event_Date = substr($Date,8,2); $Current_Month = substr($Date,5,2); $Event_Year = substr($Date,0,4); if($Current_Month == '01') { $Event_Month = January; } if($Current_Month == '02') { $Event_Month = February; } if($Current_Month == '03') { $Event_Month = March; } if($Current_Month == '04') { $Event_Month = April; } if($Current_Month == '05') { $Event_Month = May; } if($Current_Month == '06') { $Event_Month = June; } if($Current_Month == '07') { $Event_Month = July; } if($Current_Month == '08') { $Event_Month = August; } if($Current_Month == '09') { $Event_Month = September; } if($Current_Month == '10') { $Event_Month = October; } if($Current_Month == '11') { $Event_Month = November; } if($Current_Month == '12') { $Event_Month = December; } if($Summary!='') { echo " | ||
| $Event_Month $Event_Date | $Title | "; echo "|