Recuperer tous les elements en utilisant mysql WHERE IN().
Bonjour,
Pourquoi ce code en bas me donne le premier element de: $_POST['identify_friend_list'] ="4688;;;4695;;;4679;;;4683;;;4694;;;4687;;;4691;;;4680;;;4684;;;440";
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| $q=$bdd->prepare('
SELECT
*
FROM users U
LEFT JOIN blocked_users B
ON ( U.id = B.id_blocker AND B.id_blocked = :id_user )
OR ( U.id = B.id_blocked AND B.id_blocker = :id_user )
WHERE id IN (:bn) AND B.id_blocking IS NULL
');
$q->execute(array(
'bn' => $_POST['identify_friend_list'],
'id_user' => infos_profile()->id
)); |
Comment je pourrais recuperer tous les elements de $_POST['identify_friend_list'] ?
Merci.