<?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_on.gif" width="116" height="23" border="0" alt="what's new?"></A><A href="tour.php3"><IMG src="kuvat/navi_tour_off.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">
				<TR>
					<TD valign="top" bgcolor="#504C41">
						   <BR>
						   <BR>
						   <TABLE width="600" border="0" cellspacing="0" cellpadding="0" align="center" height="380">
                     		<TR>
                     				<TD valign="top">
                     						<TABLE width="230" border="0" align="right" cellpadding="0" cellspacing="0">
                     								<TR>
                     										<TD align="right"><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/kuva8.jpg" width="200" height="267"></TD>
           																						  </TR>
           																				  </TABLE>
           																		  </TD>
     																  </TR>
                     														</TABLE>
           												  </TD>
           										  </TR>
                     								<TR>
                     										<TD>&nbsp;</TD>
           										  </TR>
           								  </TABLE>
                     						<B><IMG src="kuvat/whats_new.gif" width="167" height="21" hspace="0"></B>
                     						<P>
<?php

$query = "SELECT subject,text FROM news";
$result = mysql_query($query);
if($row = mysql_fetch_array($result)) {

	$subject = stripslashes($row["subject"]);
	$text = stripslashes($row["text"]);
	
	$text = str_replace("\n","<BR>",$text);
	
	print("<B>$subject</B><BR><BR>$text");

}

?>
													</P>
  						            </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(); ?>