| 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> </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]." </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>
|