Selecting multiple rows in a Select statement using PDO

Question

I have two tables, I want to select from the first the ID of Salles for each Responsible (he may have many -> array()) .

so I want to select all the salles this responsible have, and I did this statement (which returns an empty array and I am unsure of why):

$sels = $db->prepare("SELECT salle FROM salleresp  WHERE resp = :resp");
$sels->bindParam(':resp',$rsb['matricule']);
$sels->execute();

$rss = $sels->fetchAll(PDO::FETCH_ASSOC);
$questionmarks = str_repeat("?,", count($rss)-1) . "?"; 

 $selectSalle1 = $db->prepare("SELECT * FROM salle WHERE salleId IN ($questionmarks) ");
 $selectSalle1->execute($rss);
 $showAll=$selectSalle1->fetchAll(PDO::FETCH_ASSOC);

when I do:

print_r($showAll);

it return an empty array:

array()

Any suggestions please?

Alex sadchikov · Accepted Answer · 2014-09-22 19:51:54Z

1

SELECT * FROM salle WHERE salleId IN (SELECT salle FROM salleresp  WHERE resp = :resp)

or

SELECT * FROM salle left join salleresp on (salle.salleId = salleresp.salle)
WHERE resp = :resp)

answered Sep 22, 2014 at 19:51

Alex sadchikov

362 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Selecting multiple rows in a Select statement using PDO

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related