#!/usr/bin/php
<?
require_once('./includes/header.php');
                
require_once('/home/justforfunk.com/www/mysql.inc') ;
                
				require "/home/justforfunk.com/www/mysql.inc" ;
				$sql = "select date,name,resultat,flyer,width,height,remerciements from agenda where date < now() order by date DESC" ;
				$result = mysql_db_query("justforfunk_com",$sql) ;
		   ?>
		  <table width="470" border="0" cellspacing="2" cellpadding="0" align="center">
                   <tr><td><Center>
                          <p class="presentation"><b><img src="archives/images/titre.gif" width="199" height="39"></b></p>
                          <BR></Center></td></tr>
		<?	
		$status = "0";   
		  while ($row = mysql_fetch_array($result)) {
			$status = "1" ;
			$name = $row["name"] ;
			$resultat = $row["resultat"] ;
			$date = $row["date"] ;	 
			$flyer = $row["flyer"];
			$width = $row["width"];
			$height = $row["height"];
			$remerciements = $row["remerciements"];
		?>    
                    <tr><td>           
                    	<span class="agenda">                            
                    	<? echo "$date" ?></span>
                    	&nbsp;
                    	<span class="agenda_name">
                    	<? echo "$name" ?></span><Br>
                    	<? 
                    	if (($resultat))  {
                    	?>
                    		<table width="100%" border="0" cellspacing="0" cellpadding="1" align="center" colspan="2">
                    		<tr><td class="agenda" valign="top"><span class="agenda">
                    			<? echo nl2br ($resultat) ?></span><Br>
								<? if ($remerciements) { ?>
                    			<span class="agenda"><B>Remerciements: </B>
                    			<? echo nl2br ($remerciements) ?></span> <? } ?>
                    		</td>
                    		<td width="85" align="right" valign="top">
							<? // si il y a un fly, sinon image par default
							 if ($flyer) {?>
                    			<a href="./db_images/<? echo "$flyer" ?>.jpg" target="_blank">
                    			<img src="./db_images/<? echo "$flyer" ?>_tb.jpg" width="80" height="100" border="0">
                    			</a>
								 <?
							 } else {?>
								<a href="./db_images/default.gif" target="_blank">
                    			<img src="./db_images/default_tb.gif" width="80" height="100" border="0">
                    			</a>
							 <? } ?>

                    		</td></tr>
                    		</table>
                    	<? } ?>
                    	<Br>
                    	</td></tr>
                <? 
                    }	
                 if (status == "0") {
                 echo "Une erreur s'est produite lors du traitement de la requête. Merci de ré-essayer" ?>
                 
                 <form method="post" action="mailinglist.php3" name="">
              	  <font face="Verdana, Arial, Helvetica, sans-serif" size="2">Inscrivez-vous 
                    à notre <b>mailinglist</b> et nous vous informerons dès l'apparition de nouvelles
                    dates de concert :</font> <br>
                  <input type="text" name="name" width="30" value="votre addresse e-mail">
			&nbsp;
        	  <input type="submit" name="submit" value="Submit">
  		</form>
                 
               <?  
                } 
                ?>    
                
		<tr><td>
		</td></tr>                
                
                
		  </table> 	                  
                  
                 
<? require_once('./includes/footer.php'); ?>