<?php

include("admin/functions.php");
DatabaseConnection();

?>
<HTML>
<HEAD>
<TITLE>the Latebirds</TITLE>
<META http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<LINK rel="stylesheet" href="css/style.css" type="text/css">
</HEAD>

<BODY bgcolor="#413D31" text="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF">
			<TABLE width="100%" border="0" cellspacing="0" cellpadding="0" height="23">
				<TR>
					<TD background="kuvat/tausta_yla.gif" align="center"><A href="index2.php3"><IMG src="kuvat/navi_home_off.gif" width="93" height="23" alt="home" border="0"></A><A href="news.php3"><IMG src="kuvat/navi_whats_off.gif" width="116" height="23" border="0" alt="what's new?"></A><A href="tour.php3"><IMG src="kuvat/navi_tour_on.gif" width="107" height="23" alt="tour dates" border="0"></A><A href="band.php3"><IMG src="kuvat/navi_band_off.gif" width="133" height="23" border="0" alt="band members"></A><A href="music.php3"><IMG src="kuvat/navi_music_off.gif" width="133" height="23" alt="music + songs" border="0"></A><A href="contact.php3"><IMG src="kuvat/navi_contact_off.gif" width="93" height="23" alt="contact" border="0"></A></TD>
				</TR>
			</TABLE>
		   <TABLE width="100%" border="0" cellspacing="0" cellpadding="0" height="420">
				<TR>
					<TD valign="top" bgcolor="#504C41">
						   <BR>
						   <BR>
						   <TABLE width="600" border="0" cellspacing="0" cellpadding="0" align="center">
                     		<TR>
                     				<TD valign="top">                     						<B><IMG src="kuvat/tour_dates.gif" width="153" height="21"></B>
                     						<BR>
                     						<BR>
                    						<TABLE border="0" cellspacing="0" cellpadding="0">
<?php

$query = "SELECT place,city,country,time FROM gigs";
$result = mysql_query($query);
if($row = mysql_fetch_array($result)) { do {

	$place = stripslashes($row["place"]);
	$city = stripslashes($row["city"]);
	$country = stripslashes($row["country"]);
	$time = strtotime($row["time"]);
	
	
	
?>
	                                		<TR valign="top">
                            					<TD width="59" nowrap><B><?php print date("l",$time); ?>&nbsp;&nbsp;</B></TD>
                             					<TD width="154" nowrap>&nbsp;&nbsp;<?php print date("F",$time)." ".date("jS",$time)." "; ?> (<?php print date("g",$time)." ".date("a",$time); ?>)&nbsp;&nbsp;</TD>
                             					<TD width="387">
<?php 

print $place;
if($city != "") { print(", ".$city); }
if($country != "") { print(", ".$country); }

?>
														</TD>
                         					</TR>
<?php } while($row = mysql_fetch_array($result)); } ?>
                                		</TABLE>
                                       <BR>                 						      
                                       <BR>    
                 						      <TABLE border="0" cellspacing="0" cellpadding="1">
                                       		<TR>
                                       				<TD bgcolor="#2A271F">
                                       						<TABLE width="100%" border="0" cellspacing="0" cellpadding="5">
                                       								<TR>
                                       										<TD bgcolor="#413D31"><IMG src="kuvat/tour_dates_kuva.jpg" width="500" height="165"></TD>
                             										  </TR>
                                								</TABLE>
                             						  </TD>
                             				  </TR>
                                		</TABLE>           						        
                 				  </TD>
           				  </TR>
                     		</TABLE>
			            <BR>
              <BR></TD>
				</TR>
			</TABLE>
		   <TABLE width="100%" border="0" cellspacing="0" cellpadding="0" height="23">
				<TR>
					<TD background="kuvat/tausta_ala.gif" align="center">&nbsp;</TD>
				</TR>
			</TABLE>

</BODY>
</HTML>
<?php mysql_close(); ?>
