Requète SQL avec jointure

cdc_personnes
id 
nom 
prenom
cdc_manifestations
idmanif
dmanif (les dates de type date)
lieu
event
cdc_repondre (table où les personnes ont apporté leurs réponses)
idrepon
idpers
idmanif
reponse (de type varchar)

en sélectionnant une date je souhaiterai que cela me retourne les réponses des membres concerné uniquement par cette date

lorsque je sélectionne une date cela me retourne bien l'url voulu c'est à dire l'id de la dmanif "ppeffectif_indiv.php?idmanif=488"

SELECT *
FROM cdc_repondre R
LEFT JOIN cdc_personnes P ON P.id = R.idpers
LEFT JOIN cdc_manifestations M ON M.idmanif=R.idmanif 
WHERE M.idmanif = '488' 
  AND dmanif  = '2016-12-24'

SELECT nom,prenom,dmanif,reponse
FROM cdc_repondre
LEFT JOIN cdc_personnes ON cdc_personnes.idpers = cdc_repondre.idpers
LEFT JOIN cdc_manifestations ON cdc_manifestations.idmanif=cdc_repondre.idmanif 
WHERE cdc_manifestations.idmanif = '488' 
  AND dmanif  = '2016-12-30'

$sql = "SELECT nom,prenom,dmanif,reponse
FROM cdc_repondre
LEFT JOIN cdc_personnes ON cdc_personnes.idpers = cdc_repondre.idpers
LEFT JOIN cdc_manifestations ON cdc_manifestations.idmanif=cdc_repondre.idmanif 
WHERE cdc_manifestations.idmanif = '$idmanif' 
AND dmanif  = '$dmanif'";

$sql = "SELECT nom,prenom,dmanif,reponse
FROM cdc_repondre
LEFT JOIN cdc_personnes ON cdc_personnes.idpers = cdc_repondre.idpers
LEFT JOIN cdc_manifestations ON cdc_manifestations.idmanif=cdc_repondre.idmanif 
WHERE cdc_manifestations.idmanif = '$idmanif' 
AND dmanif  = '$dmanif'";
$requete = $bdd->prepare($sql);
$requete->execute();
var_dump $idmanif;
var_dump $dmanif;
var_dump $sql;
while ($donnees = $requete->fetch()) {

?>          
		<tr>
			<td><?php echo $donnees->nom; ?></td>
			<td><?php echo $donnees->prenom; ?></td>
			<td><?php echo $donnees->reponse; ?></td>		
		</tr>
<?php
}
?>

SELECT nom,prenom,dmanif,reponse FROM cdc_repondre LEFT JOIN cdc_personnes ON cdc_personnes.idpers = cdc_repondre.idpers LEFT JOIN cdc_manifestations ON cdc_manifestations.idmanif=cdc_repondre.idmanif WHERE cdc_manifestations.idmanif = '' AND dmanif = '' 

$PARAM  = array (
    'IDREPON'   => isset($_REQUEST['idrepon']) ? $_REQUEST['idrepon'] : '',
    'IDPERS'    => isset($_POST['idpers']) ? $_POST['idpers'] : '',
    'IDMANIF'   => isset($_POST['idmanif']) ? $_POST['idmanif'] : '',
    'REPONSE'   => isset($_POST['reponse']) ? $_POST['reponse'] : '',
);

if (isset($_REQUEST['action']) AND !empty($_REQUEST['action'])) {
    
    switch($_REQUEST['action']) {
		case 'ajouter':
            $sql =	"INSERT INTO cdc_repondre (idpers, idmanif, reponse)
                    VALUES ('".$_SESSION['idpers']."','".$PARAM['IDMANIF']."', '".$PARAM['REPONSE']."')";
            $requete = $bdd->prepare($sql);
            $requete->bindParam(':idrepon', $PARAM['IDREPON']);
            $requete->bindParam(':idpers', $_SESSION['idpers']);
            $requete->bindParam(':idmanif', $PARAM['IDMANIF']);
            $requete->bindParam(':reponse', $PARAM['REPONSE']);
            $requete->execute();
            break;
    }
		echo "<div style='color:red'>Merci pour ta réponse</div><br/>";
}
    $sql = "SELECT *
            FROM cdc_manifestations
            WHERE cdc_manifestations.publier = false
            AND cdc_manifestations.idmanif NOT IN
                (SELECT distinct cdc_repondre.idmanif 
				FROM cdc_repondre
				WHERE cdc_repondre.idpers = ".$_SESSION['idpers'].")
                ORDER BY cdc_manifestations.dmanif ASC";
    $requete = $bdd->prepare($sql);
    $requete->execute();
    $nb = $requete->rowCount();
	
	if($nb < 1) {
		$erreur = "<div class='erreur'>Aucune sortie n'est prévue pour s'inscrire.....</div>";
	} else {
		$success = "<div class='success'>Merci de t'inscrire pour les sorties.....</div>";
	}
?>
<?php echo $success; ?>
<?php echo $erreur; ?>
<div id="content">
<?php
	while ($donnees = $requete->fetch()) {
?>
<form method="post">
	<table cellpadding="0" cellspacing="3">     
		<tr>
			<th bgcolor="#D6DFF7" >Date de la sortie :</th>
			<td style="color:#808080"><?php echo dateFR($donnees->dmanif) ?></td>
			<th bgcolor="#D6DFF7">Objet :</th>
			<td colspan="5" style="color:#808080"><?php echo $donnees->event;?></td>						
		</tr>	
		<tr>
			<th bgcolor="#D6DFF7">Lieu :</th>
			<td style="color:#808080"><?php echo $donnees->lieu; ?></td>
		</tr>
		<tr>		
			<th bgcolor="#D6DFF7">Ma réponse :</th>
			<td>
				<select name="reponse" size="1">
					<option value="present">Je serai Présent</option>
					<option value="absent">Je serai Absent</option>
					<option value="saispas">Je ne sais pas encore</option>
				</select>
			</td>
			<th><input type="hidden" name="idmanif" value="<?php echo $donnees->idmanif; ?>" /></th>
			<td>
				<input type="hidden" name="action" value="ajouter" />
				<input type="submit" name="submit" value="Envoyer ma réponse pour cette sortie" />
			</td>
		</tr>
	</table>
</form>
<hr/>
	
<?php
	}
?>      
</div>

$sql = "SELECT nom,prenom,dmanif,reponse
FROM cdc_repondre
LEFT JOIN cdc_personnes ON cdc_personnes.idpers=cdc_repondre.idpers
LEFT JOIN cdc_manifestations ON cdc_manifestations.idmanif=cdc_repondre.idmanif 
WHERE cdc_manifestations.idmanif='".$PARAM['IDMANIF']."' 
AND dmanif='$dmanif'";

SELECT cdc_personnes.nom, cdc_personnes.prenom, cdc_repondre.reponse
FROM cdc_personnes, cdc_repondre
WHERE cdc_repondre.idmanif='488' 
AND cdc_repondre.idpers=cdc_personnes.idpers

$sql = "SELECT nom,prenom,reponse
FROM cdc_repondre R
LEFT JOIN cdc_personnes P ON P.idpers = R.idpers
WHERE R.idmanif = ".$PARAM['IDMANIF'];
echo "$sql:".$sql."<br>"; 
echo "$idmanif:". var_dump ($idmanif)."<br>";
echo "$param:".var_dump ($param)."<br>";

$requete = $bdd->prepare($sql);
$requete->execute();


while ($donnees = $requete->fetch()) {
?>          
		<tr>
			<td><?php echo $donnees->nom; ?></td>
			<td><?php echo $donnees->prenom; ?></td>
			<td><?php echo $donnees->reponse; ?></td>		
		</tr>
<?php
}
?> 

SELECT nom,prenom,reponse FROM cdc_repondre R LEFT JOIN cdc_personnes P ON P.idpers = R.idpers WHERE R.idmanif = :SELECT nom,prenom,reponse FROM cdc_repondre R LEFT JOIN cdc_personnes P ON P.idpers = R.idpers WHERE R.idmanif =
NULL :
array(4) { ["IDREPON"]=> string(0) "" ["IDPERS"]=> string(0) "" ["IDMANIF"]=> string(0) "" ["REPONSE"]=> string(0) "" } Array:

$PARAM  = array (
    'IDREPON'   => isset($_REQUEST['idrepon']) ? $_REQUEST['idrepon'] : '',
    'IDPERS'    => isset($_POST['idpers']) ? $_POST['idpers'] : '',
    'IDMANIF'   => isset($_REQUEST['idmanif']) ? $_REQUEST['idmanif'] : '',
    'REPONSE'   => isset($_POST['reponse']) ? $_POST['reponse'] : '',
);