0) { echo "
"; foreach ($tab_erreurs as $err) echo $err."
"; echo "

"; } } if ($_SESSION['participant']) { $CHEMIN_DOCS="/home/fiastre/depot"; $URL_DOCS = "http://shiva/depot"; function etape($nom_etape,$num_etape) { global $url_page; return"$nom_etape"; } $erreurs = array(); include("modules/connect.php"); include("modules/messages.php"); echo "
"; { $requete_obs_annee = mysql_query("select distinct SEQUENCE.SEQUENCE_ID, STATION_NOM, ESPECE_NOM_VERNACULAIRE, SEQUENCE.STATION_ID". " from SEQUENCE,STATION,MESURE, ESPECE ". "where ". //"where ESPECE_ID=".$_SESSION['observation']['espece_id']. " SEQUENCE.PARTICIPANT_ID=".$_SESSION['participant']. " and STATION.STATION_ID=SEQUENCE.STATION_ID". " and SEQUENCE.SEQUENCE_ID=MESURE.SEQUENCE_ID". " and SEQUENCE.ESPECE_ID=ESPECE.ESPECE_ID". //" and MESURE.MESURE_DATE >='$annee-01-01'". //" and MESURE_DATE<'".($annee+1)."-01-01'". //" AND MESURE_DATE!='0000-00-00' and MESURE_DATE>'".($annee-1)."-$mois-01'". //" and MESURE_DATE<'$annee-$mois-01'". " order by SEQUENCE.STATION_ID"); //if (mysql_num_rows($requete_obs_annee)==0) //$erreurs[] = "Tu n'as fait aucune observation sur cette espèce cette année-là"; if (mysql_num_rows($requete_obs_annee)==0) { "Vous n'avez fait aucune observation."; } if (sizeof($erreurs)>0) { echo "
"; foreach ($erreurs as $err) echo $err."
"; echo "
"; } else { $station_encours = ""; $l = 0; ?>
"; $l=0; if ($obs[3]!=$station_encours) { echo "
".$obs[2]."1er ind.2ème ind. 3ème ind.4ème ind.5ème ind.
".$obs[1]; echo $entete_tab; $station_encours=$obs[3]; } $requete_obs_seq = mysql_query("select distinct DATE_FORMAT(MESURE_DATE,'%d/%m/%Y'),". " MESURE_INDIVIDU, EVENEMENT_NOM from MESURE,EVENEMENT". " where MESURE.SEQUENCE_ID=".$obs[0]. " and MESURE.EVENEMENT_ID=EVENEMENT.EVENEMENT_ID". //" and MESURE.MESURE_DATE >='$annee-01-01'". //" and MESURE_DATE<'".($annee+1)."-01-01'". " order by EVENEMENT_NOM, MESURE_INDIVIDU"); unset($mesures); while ($mes = mysql_fetch_row($requete_obs_seq)) { $mesures[$mes[2]][$mes[1]] = $mes[0]; } foreach ($mesures as $evenement => $mesure) { echo "". "".$evenement.""; for ($ind=1; $ind<=5; $ind++) { if (isset($mesure[$ind])) echo "".$mesure[$ind].""; else echo " "; $l++; if ($l==2) $l=0; } echo ""; } } ?>