Upcoming events
prepare("SELECT * FROM tblposts INNER JOIN tbleventinfo ON tblposts.posID = tbleventinfo.posID WHERE comID = ? AND posStatus = ? AND eveStatus = ? AND eveDate > CURRENT_DATE() ORDER BY eveDate LIMIT 3 ");
$postfetch->execute(array( '5', '1', '1'));
while ($eveROW = $postfetch->fetch(PDO::FETCH_ASSOC)) {
echo '
';
echo '
';
echo '
';
echo date("d", strtotime($eveROW["eveDate"]));
echo '
';
echo '
';
echo date("M", strtotime($eveROW["eveDate"]));
echo '
';
echo '
';
echo '
'.$eveROW["posTitle"].'
';
echo '
'.date("F jS Y", strtotime($eveROW["eveDate"])).'
';
echo '
';
echo '
';
}
?>
See more
Recent events
prepare("SELECT * FROM tblposts INNER JOIN tbleventinfo ON tblposts.posID = tbleventinfo.posID WHERE comID = ? AND posStatus = ? AND eveDate < CURRENT_DATE() ORDER BY eveDate DESC LIMIT 2 ");
$postfetch->execute(array( '5', '1'));
while ($posROW = $postfetch->fetch(PDO::FETCH_ASSOC)) {
boxEvent($posROW["posID"]);
}
?>
See more