";
$query =
"select eventID, name, venue, date, time, endtime, admission, category, info, web, contact, email, showemail, img, catID, cname from events, event_categories where active=1 and category=catID and date='$show' order by catID, time, name limit $start, $perpage";
$result = MYSQL_QUERY($query);
while($row = mysql_fetch_array($result))
{$eventID = $row["eventID"];
$name = $row["name"];
$venue = $row["venue"];
$time = $row["time"];
print "
";
print "
$name
";
print "$venue: $time
";
print "";
}
print "
";
mysql_free_result($result);
$next = $start+$perpage;
$query = "select count(eventID) from events where active=1 and date='$show'";
$result =MYSQL_QUERY($query);
$row = mysql_fetch_array($result);
$total=$row["count(eventID)"];
if ($total==0)
print "