',REPLACE(fraseEstatica,'../../recursos/','../recursos/') ORDER BY IF(COALESCE(ordenPopupFrases,0)=0,999999,ordenPopupFrases) ASC, frases.fechaactualizacion DESC SEPARATOR '') as frasesEstatica, COUNT(*) as cantidadfrases FROM colegios c INNER JOIN frasescolegios ON c.idcolegio=frasescolegios.idcolegio INNER JOIN frases ON frases.idfrase=frasescolegios.idfrase WHERE httphost='".$host."' and '".date('Ymd')."' BETWEEN fechainicio AND fechafin; "); $frases=''; while($row=mysql_fetch_array($rs)) { $frases.=str_replace('

','',str_replace('

','',$row[frases])); $frases='
'.$frases.'
'; $frasesEstaticas=$row[frasesEstatica]; $cantidadfrases=$row[cantidadfrases]; } ?>