$sql = "SELECT * FROM event order by date";
mysql_connect();
$rs = mysql_DB_query("event2db", $sql);
while($row = mysql_fetch_object($rs))
{
$val = getdate();
$title = $row->title;
$body = $row->body;
$date = $row->date;
$newsplit = explode("-", $date);
if(($val[mon] <= $newsplit[1]) && ($val[year] == $newsplit[0]))
{
echo (" ");
echo ("");
printf("%s", $title);
echo("
");
printf("Date: %s/%s/%s ", $newsplit[1], $newsplit[2], $newsplit[0]);
echo("  ");
printf("%s ", $body);
echo("
");
echo(" ");
}
}
?> |