Requetes sur des tables aux meme temps

if (isset($_POST["emplacement_actuel"]) and isset($_POST["id_boitier"]) and isset($_POST["id_borne1"]) and isset($_POST["id_borne2"]) and isset($_POST["id_borne3"]))
{ 
 $empborn=$_POST['emplacement_actuel'];
$id_boi=$_POST['id_boitier'];
$id_bor1=$_POST['id_borne1'];
$id_bor2=$_POST['id_borne2'];
$id_bor3=$_POST['id_borne3'];
if (empty($_POST['emplacement_actuel']) or empty($_POST['id_boitier']) or empty($_POST['id_borne1']))
 {
  echo "Veuillez entrer un emplacement et un identifiant avec celui de la borne qui lui correspond";
 
 }
else 
 { $req = $bdd->prepare('INSERT INTO EmplacementBorne(emplacement_actuel, id_boitier, id_borne1, id_borne2, id_borne3)
        VALUES (:emplacement_actuel, :id_boitier, :id_borne1, :id_borne2, :id_borne3)');
      $req->execute(array(
       'emplacement_actuel' => $empborn,
       'id_boitier' => $id_boi,
       'id_borne1' => $id_bor1,
       'id_borne2' => $id_bor2,
       'id_borne3' => $id_bor3,));

$e ='[/contents/1068-sql-commande-select SELECT] ID_vert,ID_rouge from IdBorne 
                        WHERE EmplacementBorne.id_borne1 = IdBorne.Num_born';
         $re->$bdd->query($e);
         while($row=$re->fetch())
         
        
       {
       $ID_Y=$row['ID_vert'];
       $ID_N=$row['ID_rouge'];
       }
                       $rq->closeCursor();

$rq= $bdd->prepare('INSERT INTO FlyportOpinionInfo(ID_YES1,ID_NO1)
        VALUES (:ID_YES1, :ID_NO1)');
      $rq->execute(array(
       'ID_YES1' => $ID_Y
       'ID_NO1' => $ID_N,
       ));