UNIX_TIMESTAMP(CURDATE()) - 172800 ORDER BY cs.startDate";
$sb = "";
$stmt = $_SESSION['DBH']->prepare($sql);
$stmt->execute();
while ($row = $stmt->fetch_assoc())
{
if ($showIt == false)
{
$sb .= "\n";
$sb .= "| Date(s) | Course Title | Location | Instructor(s) | Status |
\n";
$showIt = true;
}
// massage dates
$startDate = trim($row["startDate"]);
$endDate = trim($row["endDate"]);
$startArray = explode("|", $startDate);
$endArray = explode("|", $endDate);
if ($startArray[0] == $endArray[0] && $startArray[1] == $endArray[1]) // same day!
$dates = $startArray[0] . " " . $startArray[1] . ", " . $startArray[2];
elseif ($startArray[0] == $endArray[0]) // same month
$dates = $startArray[0] . " " . $startArray[1] . "-" . $endArray[1] . ", " . $startArray[2];
elseif ($startArray[2] == $endArray[2]) // same year
$dates = $startArray[0] . " " . $startArray[1] . "-" . $endArray[0] . " " . $endArray[1] . ", " . $endArray[2];
else
$dates = $startArray[0] . " " . $startArray[1] . ", " . $startArray[2] . "-" . $endArray[0] . " " . $endArray[1] . ", " . $endArray[2];
$courseScheduleID = $row["courseScheduleID"];
$courseID = $row["courseID"];
$courseName = trim($row["courseName"]);
$location = trim($row["location"]);
$fullName = trim($row["fullName"]);
$courseFull = trim($row["courseFull"]);
$sb .= "\n";
$sb .= "| " . $dates . " | \n";
$sb .= "" . $courseName . " | \n";
$sb .= "" . $location . " | \n";
$sb .= " " . $fullName . "
| \n";
if ($courseFull == "1")
$sb .= "SOLD OUT | \n";
else
$sb .= " | \n";
$sb .= "
\n";
}
if ($showIt)
$sb .= "