= '$today' order by date limit 25";
}
else
{
$SQL = "select DATE_FORMAT(date, '%d/%m/%Y'), event, venue, doors, listings_id from listings where date >= '$today' order by date limit 25";
}
}
else if (isset($byDate))
{
$searchDate = $y . "-" . $m . "-" . $d;
$SQL = "select DATE_FORMAT(date, '%d/%m/%Y'), event, venue, doors, listings_id from listings where date >= '$searchDate' order by date limit 25";
}
else
{
$SQL = "select DATE_FORMAT(date, '%d/%m/%Y'), event, venue, doors, listings_id from listings where date >= '$today' order by date limit 25";
}
// print "$SQL\n";
$db->query($SQL);
?>
|
DATE
|
EVENT
|
VENUE
|
TIME
|
next_record())
{
if (($i % 2) == 0)
$cc = "#FFFFFF";
else
$cc = "#CC99CC";
$i++;
?>
|
p("DATE_FORMAT(date, '%d/%m/%Y')"); ?>
|
|
p("venue"); ?>
|
p("doors"); ?>
|