<?php

include_once CLASSPATH . 'box.class.php';
$box = new box();
$resid = mysql_query("select * from immobili i,localita l, tipi t where residence=1 and pubblicato=1  and t.id_tipi=i.id_tipi and l.id_localita=i.id_localita ");
echo '<ul>';
while ($r = mysql_fetch_assoc($resid)) {
    echo '<li><a href="' . $box->costruisciPath('residence', $r, $_SESSION['lan']) . '" title="' . stripslashes($r['nome_immobile_' . $_SESSION['lan']]) . '">' . stripslashes($r['nome_immobile_' . $_SESSION['lan']]) . '</a></li>';
}
echo '</ul>';