innoDB
Código PHP:
Ver original$sql = "select * from mcm_user u "
." inner join mcm_tesoreria t "
." on u.idUser=t.user "
."where t.year=".$_GET[year]." "
."order by u.rol, u.".$_GET[orden]." ASC";
myISAM
Código PHP:
Ver original$sql = "select * from mcm_user u, join mcm_tesoreria t "
."where u.idUser=t.user "
."and t.year=".$_GET[year]." "
."order by u.rol, u.".$_GET[orden]." ASC";
si?
Quim