Ressources Pédagogiques >> Formation Métier d'Ingénieur

Error in query
SELECT IFNULL(CASE WHEN (Trim(U.Nom)<>'' OR U.Nom IS NOT NULL) THEN U.Nom ELSE CONCAT(U.Prenom,' ', U.NomFamille) END,CONCAT(P.Prenom,' ', P.Nom)) AS NomComplet,IFNULL(U.LienPerso,P.LienPerso) AS LienPerso,IFNULL(U.Photo,P.Photo) AS Photo,P.Statut AS Statut FROM Personnes P LEFT JOIN Users U ON P.Personne = U.ID WHERE P.Type='Cours' AND P.CODE= ORDER BY P.Statut DESC,P.Ordre
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 'ORDER BY P.Statut DESC,P.Ordre' at line 1