Subversion Repositories Sites.obs-saisons.fr

<?
$MOIS_EN_COURS = '09';
$mois = date('m');
$annee = date('Y');

if ($mois > $MOIS_RENTREE)
  $annee = $annee+1;

$requete_obs_annee = mysql_query("select distinct SEQUENCE.SEQUENCE_ID, ESPECE_NOM_VERNACULAIRE, STATION_NOM from SEQUENCE,ESPECE,STATION,MESURE ".
"where ESPECE.ESPECE_ID=SEQUENCE.ESPECE_ID".
" and MESURE.SEQUENCE_ID=SEQUENCE.SEQUENCE_ID".
" and SEQUENCE.PARTICIPANT_ID=".$_SESSION['participant'].
" and STATION.STATION_ID=SEQUENCE.STATION_ID".
" AND MESURE_DATE!='0000-00-00' and MESURE_DATE>'".($annee-1)."-01-01'".
" and MESURE_DATE<'$annee-01-01'".
" order by STATION_NOM, ESPECE_NOM_VERNACULAIRE");

$station_encours = "";
if (mysql_num_rows($requete_obs_annee)>0)
echo "<br><br>Vos observations effectuées cette année :<br>";
?>
<form name="form_modif_obs" method="post" action="<?= $url_page ?>">
<table border="0">
<?
while ($obs = mysql_fetch_row($requete_obs_annee)) {
if ($obs[2]!=$station_encours) {
  echo "<tr><td colspan=3>&nbsp;</td></tr>";
  echo "<tr><th colspan=3 align=left>Station : ".$obs[2]."</th></tr>";
}
//if ($obs[1]!=$espece_encours) 
  echo "<tr><td>Espèce : </td><td>".$obs[1]."&nbsp;</td><td><input type='submit' class='submit' name='modifev_".$obs[0]."' value='Ajouter/modifier des observations'></td></tr>";

//$espece_encours=$obs[1];
$station_encours=$obs[2];
}
?>
</table>
</form>