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 name' at line 1select m.*, p.name as pname,p.logo, t1.name as team1 , t1.logo as logo1 , t2.name as team2, t2.logo as logo2 from tb_match as m, tb_programe as p, tb_team as t1, tb_team as t2 where m.pro_id=p.pro_id and m.team_id1=t1.team_id and m.team_id2=t2.team_id and m.mat_id=385495