New file |
0,0 → 1,38 |
<? |
$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> </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]." </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> |