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
| $TabComm=array();
$TempComm=-1;
while($row = mysql_fetch_assoc($sqlResult)) {
if($TempComm!=$row['Idcomm']){$TempComm=$row['Idcomm'];
$TabComm[$TempComm]=array("id" =>$row['Idcomm'],"nom"=>$row['Nom'],"fonction"=>$row['Fonction'],"titre"=>$row['Titre'],"agence"=>$row['Agence'],"adresse"=>$row['Adresse'],"sedentaire"=>$row['Sedentaire'],"depts"=>$row['Depts'],"tel"=>$row['Tel'],"mob"=>$row['Mob'],"fax"=>$row['Fax'],"mail"=>$row['Email'],"pass"=>$row['Password']) ;}
else { $TabComm[$TempComm]["depts"].=','.$row['Depts']; }
}
foreach ($TabComm as $EnregComm => $ArrayComm) {
?>
<tr onmouseover="this.style.backgroundColor='salmon';" onmouseout="this.style.backgroundColor='transparent';">
<?php echo '<td id="ID_'.$ArrayComm['id'].'"><form action="FicheUser.php" method="post"><input name="UserId" value="'.$ArrayComm['id'].'" type="hidden" /><input name="ButtonUserId" type="image" src="AdminPics/Modif.gif" style="cursor:pointer;" /></form></td>';
echo '<td id="ID_'.$ArrayComm['id'].'">'.$ArrayComm['nom'].'</td>';
echo '<td >'.$ArrayComm['fonction'].'</td>';
echo '<td>'.$ArrayComm['titre'].'</td>';
echo '<td>'.$ArrayComm['agence'].'</td>';
echo '<td>'.$ArrayComm['adresse'].'</td>';
echo '<td>'.$ArrayComm['sedentaire'].'</td>';
echo '<td>'.$ArrayComm['depts'].'</td>';
echo '<td>'.$ArrayComm['tel'].'</td>';
echo '<td>'.$ArrayComm['mob'].'</td>';
echo '<td>'.$ArrayComm['fax'].'</td>';
echo '<td>'.$ArrayComm['mail'].'</td>';
echo '<td>'.(($_SESSION['userType']=="MAS" or $_SESSION['userType']=="ADM")?$ArrayComm['pass']:$_SESSION['userType']).'</td>';
echo '<td>'.$ArrayComm['nom'].'</td>';
?>
</tr>
<?php
} ?> |
Partager