Quote:
Originally Posted by Curll
I'm looking for a hack or a PHP script that can put today's events from the calander on a non-vB page, namely my site's main page. Maybe something cute in a Calander square looking dealy.
Thanks
|
Hi Curl,
please use the following code to get the last 5 events in an array:
PHP Code:
$events = $DB_site->query("select * from event order by dateline DESC limit 5");
if ($DB_site->num_rows($events))
{
while ($ev = $DB_site->fetch_array($events))
{
$serveroffset = date('Z', TIMENOW) / 3600;
$fromdate = getdate(TIMENOW + (-12 - $serveroffset) * 3600);
$new_date = date('d-m-Y', TIMENOW + (-12 - $serveroffset) * 3600 );
echo $new_date," ";
// echo $ev['userid']," ";
// echo $ev['dateline']," ";
echo $ev['title'],"<BR>";
}
}
Cheers,