Como puedo hacer para poner una consulta en varias lineas. Por ejemplo el original sería:
Código PHP:
$query = "SELECT fr.*,fr.title as tituloforo, ps.subject as subject, ps.*, rp.*,count(rp.idreply) as cantreply, us.*, rp.date, DAYOFMONTH(rp.date) AS dia, DAYOFWEEK(rp.date) AS semana, MONTH(rp.date) AS mes, YEAR(rp.date) AS year, DATE_FORMAT(rp.date,'%h:%i %p') AS hora FROM foros fr, post ps, reply rp, users us WHERE fr.idforo=".$_GET['foro']." AND ps.idcat=".$idcat." AND ps.idforo=".$idforo." AND rp.idpost=ps.idpost AND us.iduser=ps.iduser GROUP BY rp.idpost ORDER BY ps.idpost,rp.idreply";
pues bien lo que quiero hacer es algo como esto:
Código PHP:
$query = "SELECT fr.*,fr.title as tituloforo, ps.subject as subject, ps.*, rp.*,count(rp.idreply) as cantreply, us.*, rp.date";
$query. = "DAYOFMONTH(rp.date) AS dia, DAYOFWEEK(rp.date) AS semana, MONTH(rp.date) AS mes, YEAR(rp.date) AS year, DATE_FORMAT(rp.date,'%h:%i %p') AS hora";
$query. = "FROM foros fr, post ps, reply rp, users us WHERE fr.idforo=".$_GET['foro']." AND ps.idcat=".$idcat." AND ps.idforo=".$idforo." AND rp.idpost=ps.idpost AND us.iduser=ps.iduser GROUP BY rp.idpost ORDER BY ps.idpost,rp.idreply";
pero no se si esto es lo correcto pues me da errores a la hora de compilar el código.
Salu2
