Subversion Repositories Sites.obs-saisons.fr

Rev

Rev 5 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
1 aurelien 1
<?
2
$MOIS_EN_COURS = '09';
3
$mois = date('m');
4
$annee = date('Y');
5
 
6
if ($mois > $MOIS_RENTREE)
7
  $annee = $annee+1;
8
 
9
$requete_obs_annee = mysql_query("select distinct SEQUENCE.SEQUENCE_ID, ESPECE_NOM_VERNACULAIRE, STATION_NOM from SEQUENCE,ESPECE,STATION,MESURE ".
10
"where ESPECE.ESPECE_ID=SEQUENCE.ESPECE_ID".
11
" and MESURE.SEQUENCE_ID=SEQUENCE.SEQUENCE_ID".
12
" and SEQUENCE.PARTICIPANT_ID=".$_SESSION['participant'].
13
" and STATION.STATION_ID=SEQUENCE.STATION_ID".
14
" AND MESURE_DATE!='0000-00-00' and MESURE_DATE>'".($annee-1)."-01-01'".
15
" and MESURE_DATE<'$annee-01-01'".
16
" order by STATION_NOM, ESPECE_NOM_VERNACULAIRE");
17
 
18
$station_encours = "";
19
if (mysql_num_rows($requete_obs_annee)>0)
20
echo "<br><br>Vos observations effectuées cette année :<br>";
21
?>
22
<form name="form_modif_obs" method="post" action="<?= $url_page ?>">
23
<table border="0">
24
<?
25
while ($obs = mysql_fetch_row($requete_obs_annee)) {
26
if ($obs[2]!=$station_encours) {
27
  echo "<tr><td colspan=3>&nbsp;</td></tr>";
28
  echo "<tr><th colspan=3 align=left>Station : ".$obs[2]."</th></tr>";
29
}
30
//if ($obs[1]!=$espece_encours)
31
  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>";
32
 
33
//$espece_encours=$obs[1];
34
$station_encours=$obs[2];
35
}
36
?>
37
</table>
38
</form>