
Global Super 8 Day - Calendar of Events
Events of Friday May 6th 2005 |
$result=mysql_query( "select count(*) from gs8dagenda where date = 6 or (date2 = 6 and time2 != 0 )" );
$row = mysql_fetch_row($result);
$count = $row[0];
echo "(".$count.") | ";
?>
Events of Saturday May 7th 2005 |
$result=mysql_query( "select count(*) from gs8dagenda where date = 7 or (date2 = 7 and time2 != 0 )" );
$row = mysql_fetch_row($result);
$count = $row[0];
echo "(".$count.") | ";
?>
Events of Sunday May 8th 2005 |
$result=mysql_query( "select count(*) from gs8dagenda where date = 8 or (date2 = 8 and time2 != 0 )" );
$row = mysql_fetch_row($result);
$count = $row[0];
echo "(".$count.") | ";
?>
Events of Monday May 9th 2005 |
$result=mysql_query( "select count(*) from gs8dagenda where date = 9 or (date2 = 9 and time2 != 0 )" );
$row = mysql_fetch_row($result);
$count = $row[0];
echo "(".$count.") | ";
?>
Events of Sunday May 8th 2005
|
$result=mysql_query( "select distinct event_id, city, country, location, event_id from gs8dagenda where date = 8 or (date2 = 8 and time2 != 0 ) order by city" );
$i=0;
while( $row=mysql_fetch_array($result) ) {
echo "";
echo "".$row['city'].", ".$row['country']." | ";
echo "".$row['location']." | ";
echo "» show info | ";
}
?>
|
include 'incl_nav.shtml';
?>
The Cities
include 'incl_event_cities.shtml';
?>
|