=-15 AND CURDATE()<=lm_al AND lm_prezzo>0")); $totlastminute=$arr2['tot']; $res2=eseguiqry("SELECT DISTINCT categoria, COUNT(*) AS tot, MIN(`lm_prezzo`) AS min, MAX(`lm_prezzo`) AS max FROM hotel WHERE visibile AND DATEDIFF(CURDATE(),lm_dal)>=-15 AND CURDATE()<=lm_al AND lm_prezzo>0 GROUP BY categoria"); $qry="select id,categoria,nome,paese,provincia,img1,lm_dal,lm_al,lm_minnotti,lm_minpersone,lm_trattamento,lm_prezzo,lm_prezzonormale from hotel WHERE visibile $where AND DATEDIFF(CURDATE(),lm_dal)>=-15 AND CURDATE()<=lm_al AND lm_prezzo>0 ORDER BY lm_prezzo,lm_minnotti,lm_minpersone"; $limit=" LIMIT $s,10"; $res=eseguiqry($qry); $q=quanterighe($res); $res=eseguiqry($qry.$limit); chiudidb(); if ($q<=0) { $err="
".$_SESSION['llasErrvuoto'].""; } $pagine=""; if ($s>0) $pagine.=""; $pagine.=" ".$_SESSION['llasPagina']." ".ceil(($s+1)/10)." ".$_SESSION['llasDi']." ".ceil($q/10)." "; if ($q>10 && $s+10<$q) $pagine.="
"; ?>

() | ".ucfirst(show_categoria($arr2['categoria'],true))." (".$arr2['tot']." ".($arr2['tot']==1?$_SESSION['llasOfferta']:$_SESSION['llasOfferte'])." ".$_SESSION['llasDa']." ".$arr2['min']."€".($arr2['tot']==1?"":" ".$_SESSION['llasA']." ".$arr2['max']."€").") | "; } ?> * ":"")?> € * ".$_SESSION['llasInvecedi']." ".$arr['lm_prezzonormale']."":"")?> : , : , : ">, ()