1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
| <?php
require("../../config.inc.php");
mysql_select_db("ATS"); // Sélection de la base de données
//$reponse = mysql_query("SELECT * FROM `ATS_statut`") or die(mysql_error());
$reponse = mysql_query("SELECT ATS_statut.an,ATS_statut.eq_sexe,ATS_statut.eq_cat,ATS_statut.eq_div,ATS_statut.note,TB_statut.description FROM `ATS_statut` LEFT JOIN TB_statut ON ATS_statut.type = TB_statut.code
where passeport=$no_passeport ORDER BY ATS_statut.debut DESC") or die(mysql_error());
//$nb = mysql_num_rows($reponse);
//echo "<h2><strong>Nombre de réponses obtenues :</strong> ".$nb."</h2>";
?>
<form method='POST' action='ent_statut_maj.php'>
<table align="center" width="90%" border="1" cellpadding="5">
<caption><h2>Lien avec l'ATS</h2></caption>
<tr>
<th width="20">Année</th>
<th width="35">Description</th>
<th width="15">Sexe</th>
<th width="15">Cat.</th>
<th width="15">Div.</th>
<th width="80">Note</th>
</tr>
<?php
while ($donnees = mysql_fetch_array($reponse) )
$type = rtrim($donnees['description']);
echo $type;
{
if ($donnees['fin'] == '0000-00-00') { $fin = ''; } else { $fin = $donnees['fin']; }
?>
<tr>
<td align="center"><input type="text" name="annee" value="<?php echo $donnees['an'];?>" size="4"></td>
<td align="center">
<?php
echo "<select name=type value='".$type."'>";
$tablocation=array('ND'=>'Non déterminé',
'AR'=>'Arbitre',
'AS'=>'Assistant',
'BE'=>'Bénévole',
'CT'=>'Comité technique',
'CA'=>'CA',
'EM'=>'Employé',
'EN'=>'Entraîneur',
'GE'=>'Gérant',
'JO'=>'Joueur');
while(list($key,$val)=each($tablocation)){
if ($key==$type)
echo "<option value='".$key."' selected>".$val."</option>";
else
echo "<option value='".$key."'>".$val."</option>";
}
?>
<strong><?php echo $donnees['description']; ?></strong>
</td> |
Partager