<?php 


$sqla = "SELECT NomService FROM SERVICES"; 

$reponsea = mysql_query($sqla); 


$sqlb = "SELECT NomCellule FRM CELLULES INNER JOIN SERVICES WHERE IdService = RefSevice"; 

$reponseb = mysql_query($sqlb) 

// Ensuite je fais deux boucle imbirqué pour la liste 


while ($donneesa = mysql_fetch_array($reponsea)) 
{ 

?> 

    <optgroup label=" <?php echo "$donneesa[ 'NomService']" ?>" > 

        <?php 
        while ($donneesb = mysql_fetch_array($reponseb)) 
        { 
        ?> 

            <option><?php echo "$donneesb[ 'NomCellule']" ?></option> 

        <?php 
        } 
        ?> 

    </optgroup> 

<?php 
} 
?>

<?php

$requete  = 'SELECT `t2`.`NomService`, `t1`.`NomCellule` FROM `CELULLES` as `t1` ';
$requete .= 'LEFT JOIN `SERVICES` as `t2` ON (`t1`.`IdService` = `t2`.`RefSevice`) ';

$query = mysql_query($requete) or die(mysql_error());

// Mise en forme ...
?>

<?php

while ($donneesa = mysql_fetch_array($reponsea))
{
	$service = $donneesa['NomService'];
	echo "$service ";
	while ($donneesb = mysql_fetch_array($reponseb))
		{
			$cellule = $donneesb['NomCellule'];
			echo "Bien joué TINTIN";
			echo "$cellule " ;
		}

}

?>

<?php

$sqlb = "SELECT NomCellule FROM CELLULES INNER JOIN SERVICES ON IdService = RefService WHERE NomService = '".$donneesa['NomService']."' ORDER BY CodeCel ASC";

?>