Blame | Last modification | View Log | RSS feed
<?
function afficherErreurs($tab_erreurs) {
if (sizeof($tab_erreurs)>0) {
echo "<div class='erreurs'>";
foreach ($tab_erreurs as $err)
echo $err."<br>";
echo "</div><br>";
}
}
include("connect.php");
/*** Liste des participants***/
/*** Requête de sélection pour l'affichage de la bd ***/
$req_participants = mysql_query("select count(PARTICIPANT_ID), COMMUNE_LATITUDE, COMMUNE_LONGITUDE, COMMUNE_NOM from PARTICIPANT,COMMUNE".
" where PARTICIPANT.COMMUNE_ID=COMMUNE.COMMUNE_ID and PARTICIPANT_ADULTE=1".
" group by COMMUNE.COMMUNE_ID");
include ("modules/cartes/local_participants.php") ;
?>
<center>
<div id="map" class="carte"></div>
</center>
<?
/*$req_participants = mysql_query("select PARTICIPANT_ID,PARTICIPANT_ECOLE,PARTICIPANT_PSEUDO,PARTICIPANT_NOM,PARTICIPANT_PRENOM,PARTICIPANT_ADRESSE,COMMUNE_NOM,NIVEAU_NOM,PARTICIPANT_VISIBLE".
" from COMMUNE, PARTICIPANT left join NIVEAU on PARTICIPANT.NIVEAU_ID=NIVEAU.NIVEAU_ID where PARTICIPANT.COMMUNE_ID=COMMUNE.COMMUNE_ID and PARTICIPANT_VISIBLE=1".
" order by PARTICIPANT_PSEUDO");
echo mysql_error();
?>
<center>
<table class="spip">
<tr class="row_even" style='font-weight: bold; font-size: 11px;'>
<td>Pseudo</td>
<td>Nom</td>
<td>Ecole</td>
<td>Niveau</td>
<td>Commune</td>
<td>Adresse</td>
</tr>
<?
$styleligne = array("odd","even");
$l = 0;
$i=0;
while ($participant = mysql_fetch_row($req_participants)) {
echo "<tr class='row_".$styleligne[$l]."'><td>".$participant[2]."</td>
<td>".$participant[3]." ".$participant[4]."</td>
<td>".$participant[1]."</td>
<td>".$participant[7]."</td>
<td>".$participant[6]."</td>
<td>".$participant[5]."</td>
</tr>";
$l++;
if ($l==2)
$l=0;
}
?>
</table>
</center>
<? */
?>