$dbHost = "p3plcpnl0849.prod.phx3.secureserver.net"; $dbUser = "RWHWeb"; $dbPass = "Boykin1!"; $dbDatabase = "RWHWeb"; // Connect to DB $con=mysqli_connect($dbHost, $dbUser, $dbPass,$dbDatabase); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // initiate some vars $cal_str = ""; // $gb_str is the string we'll append entries to $get_rs = mysqli_query($con,"SELECT *, DATE_FORMAT(start_date, '%m/%d/%y') stdate, DATE_FORMAT(end_date, '%m/%d/%y') enddate, DATE_FORMAT(start_time, '%h:%i %p') sttime, DATE_FORMAT(end_time, '%h:%i %p') endtime FROM Calendar WHERE (start_date >= DATE(NOW()) or end_date >= DATE(NOW())) ORDER BY start_date"); // While there are still results while($get_row = mysqli_fetch_array($get_rs)) { $id = $get_row["id"]; $title = $get_row["title"]; $desc = $get_row["description"]; $loc = $get_row["location"]; $locname = $get_row["location_name"]; $stdate = $get_row["stdate"]; $sttime = $get_row["sttime"]; $enddate = $get_row["enddate"]; $endtime = $get_row["endtime"]; if ($enddate == "00/00/00") { $caldte="($stdate $sttime - $endtime)"; } else { $caldte="($stdate - $enddate)"; } // Append to string we'll print later on $cal_str .= "