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 lib_type_adh' at line 2 Impossible d'effectuer la requête SELECT DISTINCT asso_adh_secteur.id_type_adh,asso_adh_secteur.id_adherent,ldv_type_adh.* FROM asso_adh_secteur INNER JOIN ldv_type_adh ON asso_adh_secteur.id_type_adh=ldv_type_adh.id_type_adh WHERE id_adherent= ORDER BY lib_type_adh