setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $conn->prepare("SELECT * FROM `scc24` WHERE `type` = 'faculty' ORDER BY (`date_created` = CURDATE()) DESC, `date_created` DESC");
$stmt->execute();
$content = $stmt->fetchAll(PDO::FETCH_ASSOC);
$serialNumber = 1;
foreach ($content as $notice) {
echo '
| ' . $serialNumber . ' |
' . htmlspecialchars($notice['title']) . ' |
|
';
$serialNumber++;
}
echo '';
} catch (PDOException $e) {
echo "Error: " . htmlspecialchars($e->getMessage()) . "
";
}
?>