|
<%
$data = include_html("../include_menu.html","");
echo($data);
%> |
|
<%
$data = include_html("../include_flash.html","");
echo($data);
%> |
 |
Event Calendar
<%
if (isset($submit))
{
echo "Results ";
//default search always includes country
$searchterms="EventLocationCountry='$_POST[country]' AND EventDate >= curdate()";
//determine all games or a specific one
if($_POST[event_game] != "0")
{
$searchterms=$searchterms . " AND EventFeatureGame='$_POST[event_game]'";
}
//determine all states or a specific one
if($_POST[state] != "0")
{
$searchterms=$searchterms . " AND EventLocationState='$_POST[state]'";
}
//Testing searchterms by showing them
//echo "$searchterms
";
$query="SELECT DATE_FORMAT(EventDate, '%b %d, %Y') AS demodate,EventID,EventFeatureGame,EventType,EventFormalName,EventLocationName,EventLocationCity,EventLocationState,EventLocationCountry,EventLocationStreetAddress,EventLocationZip,EventLocationPhone,EventLocationPhone FROM bheventlog WHERE $searchterms ORDER BY EventDate DESC";
//$query="SELECT * FROM events WHERE $searchterms";
$result=mysql_db_query($db, $query ,$connection) or die("Error in query.");
//Output results in a table
%>
| Date |
Location |
<% while($myrow = mysql_fetch_array($result))
{
$demodate = $myrow["demodate"];
$location = $myrow["EventLocationName"];
$address = $myrow["EventLocationStreetAddress"];
$city = $myrow["EventLocationCity"];
$state = $myrow["EventLocationState"];
$country = $myrow["EventLocationCountry"];
$zip = $myrow["EventLocationZip"];
$phone = $myrow["EventLocationPhone"];
$email = $myrow["EventLocationEmail"];
$game = $myrow["EventFeatureGame"];
%>
| <% echo $demodate; %> |
<% echo $game; %>
<% echo $location; %>
<% echo $address; %>
<% echo "$city $state"; %>
<% echo "$country $zip"; %>
<% echo $phone; %>
<% if ($email && $email != "none")
{
%> Email: <% echo $email; %>
<%
}
%> |
<% } %>
<%
// memory flush
mysql_free_result($result);
}
%>
 |
|
|
 |
|