New file |
0,0 → 1,68 |
<? |
|
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> |
<? */ |
|
?> |