Erreur SQL : SQLSTATE[42000]: Syntax error or access violation: 1064
Bonjour à vous,
Je suis à la recherche d'une solution pour l'erreur :
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IdModClasse'].' ORDER BY NomEl'
Code:
1
2
3
4
5
6
7
|
if($IdModClasse !== 'tout') {
$choixel=$bdd->query('SELECT * FROM eleve e INNER JOIN eleveclasse c ON e.idEl = c.idEl WHERE c.CodeClasse = '.$IdModClasse.' ORDER BY NomEl');
}
else/*($IdModClasse == 'tout')*/ {
$choixel=$bdd->query('SELECT * FROM eleve e INNER JOIN eleveclasse ec ON e.idEl = ec.idEl INNER JOIN classe c ON c.CodeClasse = ec.CodeClasse ORDER BY c.LibelleClasse ');
} |
Je ne comprend pas ...
Une idée ?
