select distinct guides_pays.id_pays, guides_pays.nom_pays_fr, guides_pays.nom_pays_en from guides_pays  
		inner join guides_infos on guides_pays.id_pays=guides_infos.int_2 where guides_infos.id_info= order by guides_pays.nom_pays_fr<hr>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 guides_pays.nom_pays_fr' at line 2