1 pièce(s) jointe(s)
SQLSTATE[42000]: Syntax error or access violation: 1064
Bonjour à tous,
pourriez vous m'aider à savoir d'ou provient l'erreur que j'ai dans ma requête SQL.
Erreur :
Citation:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND m1.user1read = 'no' AND Effer_Utilisateur.id = m1.user2) OR (m1.user2 = ...' at line 1
Code de la requête :
Code:
1
2
3
4
5
6
7
8
9
| function getMessageNonLu($idMembre){
$pdo = monPDO::getPDO();
$SQL = "SELECT m1.id, m1.title, m1.timestamp, count(m2.id) as reps, Effer_Utilisateur.id as userid, Effer_Utilisateur.login FROM Effer_Messagerie as m1, Effer_Messagerie as m2, Effer_Utilisateur WHERE ((m1.user1 = $idMembre AND m1.user1read = 'no' AND Effer_Utilisateur.id = m1.user2) OR (m1.user2 = $idMembre AND m1.user2read = 'no' AND Effer_Utilisateur.id = m1.user1)) AND m1.id2 = '1' AND m2.id = m1.id GROUP BY m1.id ORDER BY m1.id desc";
$stmt = $pdo->prepare($SQL);
$stmt->execute();
$resultat = $stmt->fetchAll(PDO::FETCH_ASSOC);
$stmt->closeCursor();
return $resultat;
} |
Format de la BDD : ( InnoDB )
Pièce jointe 646970
Merci à vous
