Gestion Membre

$sql = "SELECT tbg.nom_gestion nom_gestion, tbg.id_gestion id_gestion, (NOT(tbag.rid_adherent IS NULL) AND tbag.rid_adherent = '" . $donnees['id_adherent'] . "') checked FROM tb_gestion tgb LEFT JOIN tb_adherent_gestion tbag ON tbag.rid_gestion = tbg.id_gestion";
$requete1 = $bdd->prepare($sql);       
$requete1->execute();
while ($donnees = $requete1->fetch(PDO::FETCH_ASSOC))
{
 echo "<tr>";
 echo "<td width='20%'>".$donnees['nom_gestion']."</td>";
 echo "<td width='20%'><input type='checkbox' name='nom_gestion[]' value='".$donnees['id_gestion']."'". ($donnees['checked'] ? ' checked="checked"':'') . "></td>";
 echo "</tr>";
}
$requete1->closeCursor();

SELECT
    tbg.nom_gestion nom_gestion,
    tbg.id_gestion id_gestion,
    NOT(tbag.rid_adherent IS NULL) checked
FROM tb_gestion tbg
    LEFT JOIN tb_adherent_gestion tbag
        ON tbag.rid_gestion = tbg.id_gestion
        AND tbag.rid_adherent = 'mettre_ici_l_id_adherent'
ORDER BY tbg.id_gestion

'mettre_ici_l_id_adherent'

$PARAM['ID_ADHERENT']

			echo"<td width='15%'>";
			echo"<select name='nom_statut' class='content_input' disabled=''>";
			echo"<option value=''>- - - Statut - - -</option>";
	$sql = "SELECT
		tb_statut.nom_statut,
		tb_statut.id_statut,
		NOT(tb_adherent_statut.rid_adherent IS NULL) selected
		FROM tb_statut
	    LEFT JOIN tb_adherent_statut
        ON tb_adherent_statut.rid_statut = tb_statut.id_statut
        AND tb_adherent_statut.rid_adherent ='".$PARAM['ID_ADHERENT']."'
		ORDER BY tb_statut.id_statut";
	$requete2 = $bdd->prepare($sql);
	$requete2->execute();

		while ($donnees = $requete2->fetch(PDO::FETCH_ASSOC))
		{
			echo"<option value='".$donnees["id_statut"]."'>".$donnees["nom_statut"]." ". ($donnees['selected'] ? ' selected="selected"':'') . "</option>\n";
		}
			echo"</select>";
			echo"</td>";
	$requete2->closeCursor();

echo"<option value='".$donnees["id_statut"]."'". ($donnees['selected'] ? ' selected="selected"':'') . ">".$donnees["nom_statut"]."</option>\n";

		case 'edit':
			$sql = ("SELECT *
					FROM tb_adherent
					WHERE id_adherent='" . $PARAM['ID_ADHERENT'] . "'
					ORDER BY nom ASC");
			$requete = $bdd->prepare($sql);
			$requete->execute();
			$reponse = $requete->setFetchMode(PDO::FETCH_ASSOC);
			$donnees = $requete->fetch();

					<a href="./index.php?body=gestion_membre&type=compte&action=edit&id_adherent=<?php echo $donnees['id_adherent'];?>" onclick="ad_user()">						

SELECT *
FROM tb_adherent tba
    -- partie pour récupérer le status de l'adhérent	
    INNER JOIN tb_adherent_statut tbas
        ON tbas.rid_adherent = tba.id_adherent
    INNER JOIN tb_statut tbs
        ON tbas.rid_statut = tbs.id_statut
		
WHERE id_adherent='" . $PARAM['ID_ADHERENT'] . "'
ORDER BY nom ASC

ORDER BY

SELECT tba.*, tbs.nom_statut, GROUP_CONCAT(tbg.nom_gestion SEPARATOR ', ') nom_gestions
FROM tb_adherent tba
    LEFT OUTER JOIN tb_adherent_statut tbas
        ON tbas.rid_adherent = tba.id_adherent
	LEFT OUTER JOIN tb_statut tbs
        ON tbs.id_statut = tbas.rid_statut

	LEFT OUTER JOIN tb_adherent_gestion tbag
        ON tbag.rid_adherent = tba.id_adherent
	LEFT OUTER JOIN tb_gestion tbg
        ON tbg.id_gestion = tbag.rid_gestion

WHERE id_adherent='" . $PARAM['ID_ADHERENT'] . "'

if (isset($_POST['nom_gestion'])) {
		foreach($PARAM['NOM_GESTION'] as $nom_gestion)
		{
			$sql = 'INSERT INTO tb_adherent_gestion (rid_adherent, rid_gestion)
					VALUES ("'.$adherent_insert.'", "'.$nom_gestion.'")';
			$requete = $bdd->prepare($sql);
			$requete->bindParam(':rid_adherent',			$adherent_insert);
			$requete->bindParam(':rid_gestion',				$nom_gestion);
			$requete->execute();
		}
}
if (isset($_POST['nom_statut'])) {
	$nom_statut = $PARAM['NOM_STATUT'];

			$sql = 'INSERT INTO tb_adherent_statut (rid_adherent, rid_statut)
					VALUES ("'.$adherent_insert.'", "'.$nom_statut.'")';
			$requete = $bdd->prepare($sql);
			$requete->bindParam(':rid_adherent',			$adherent_insert);
			$requete->bindParam(':rid_statut',				$nom_statut);
			$requete->execute();
}
			break;

			$sql = "UPDATE tb_adherent_gestion
					SET rid_adherent=:rid_adherent, rid_gestion=:rid_gestion";
			$requete = $bdd->prepare($sql);
			$requete->bindParam(':rid_adherent',			$PARAM['RID_ADHERENT']);
			$requete->bindParam(':rid_gestion',				$PARAM['RID_GESTION']);	
			$requete->execute();

			$sql = "UPDATE tb_adherent_statut
					SET rid_adherent=:rid_adherent, rid_statut=:rid_statut";
			$requete = $bdd->prepare($sql);
			$requete->bindParam(':rid_adherent',			$PARAM['RID_ADHERENT']);
			$requete->bindParam(':rid_statut',				$PARAM['RID_STATUT']);
			$requete->execute();

SELECT *
FROM tb_adherent
WHERE id_adherent='1';

SELECT tba.*, tbs.nom_statut, GROUP_CONCAT(tbg.nom_gestion SEPARATOR ', ') nom_gestion
FROM tb_adherent tba
    LEFT OUTER JOIN tb_adherent_statut tbas
        ON tbas.rid_adherent = tba.id_adherent
 LEFT OUTER JOIN tb_statut tbs
        ON tbs.id_statut = tbas.rid_statut

 LEFT OUTER JOIN tb_adherent_gestion tbag
        ON tbag.rid_adherent = tba.id_adherent
 LEFT OUTER JOIN tb_gestion tbg
        ON tbg.id_gestion = tbag.rid_gestion
     WHERE id_adherent='1';