#!/usr/bin/php
<?
require_once('./includes/header.php');
                
require_once('/home/justforfunk.com/www/mysql.inc') ;
				
		$sql = "select date,name,description,flyer,width,height from agenda where date >= now() order by date" ;
		$result = mysql_db_query("justforfunk_com",$sql) ;
		   ?>
		   <Center>
		   <p class="presentation"><b><img src="agenda/images/titre.gif" width="127" height="59"></b></p></center>
		  <table width="470" border="0" cellspacing="2" cellpadding="1" align="center">
		<?	
		$status = "0";   
		  while ($row = mysql_fetch_array($result)) {
			$status = "1" ;
			$name = $row["name"] ;
			$description = $row["description"] ;
			$date = $row["date"] ;
			$flyer = $row["flyer"] ;
			$width = $row["width"];
			$height = $row["height"];
		?>    
                    <tr><td>       
                    	<span class="agenda">             
                    	<? echo "$date" ?> &nbsp;</span>
                    	<span class="agenda_name">
                    	<? echo "$name" ?></span>
                    	<div class="agenda">
                    	<? echo nl2br ($description) ?></div><Br><Br>
                    	
                    	</td>
                    	<? if ($flyer) {
                    	?>
                    	<td width="80" valign="top"><br>
                    	<a href="./db_images/<? echo "$flyer" ?>.jpeg" target="_blank">
                    	<img src="./db_images/<? echo "$flyer" ?>_tb.jpeg" width="80" border="0">
                    	</a>
                    	</td>
                    	<?
                    	}
                    	?>
							
                    	</tr>
                <? 
                    }	
                 if ($status == "0") {
                 echo '<span class="agenda">Pas de dates annoncées pour le moment!</span><br>'; ?>
                 
                 <form method="post" action="mailinglist.php3" name="">
              	  <span class="agenda">Inscrivez-vous 
                    à notre <b>mailinglist</b> et nous vous informerons dès l'apparition de nouvelles
                    dates de concert :</span> <br>
                  <input type="text" name="name" width="30" value="votre addresse e-mail">
			&nbsp;
        	  <input type="submit" name="submit" value="Submit">
  		</form>
                 
               <?  
                } 
                ?>    
                
		<tr><td colspan="2">
		<center>&nbsp;&nbsp;&nbsp;<img src="agenda/images/booking.gif" width="142" height="58"><br>
		<span class="agenda">
		Nicolas Jones<br>
		E-mail: booking@justforfunk.com<br>
		Fax: ++41 (0) 22/364 28 91
		</span>
		</center>
		</td></tr>                
                
                
		  </table> 	                  
               
<? require_once('./includes/footer.php'); ?>