$obj = $db->fetch_object($resql);
if ($obj) {
$titre = "";
// You can use here results
print '<tr><td>';
print "<a href=\"fiche.php?id={$obj->rowid}\">{$obj->rowid}</a>";
// print $obj->rowid;
//print $product_static->getNomUrl(1,'',24);
print '<td>' . $obj->ref_interne . '</td>';
// print '<td>'.$obj->fk_biens.'</td>';
//print '<td>'.$obj->getNomUrl(1,'fk_societe').'</td>';
// ref du biens
$biens = new Logement($db);
$biens->fetch($obj->fk_biens);
// $titre=$biens->ref;
$titre = $biens->getbiensUrl(1) . $titre;
print '<td>' . $titre . '</td>';
print '<td> type: ' . $biens->nb_piece . '</td>';
print '<td>' . dol_print_date($obj->date_contrat) . '</td>';
print '<td>' . dol_print_date($obj->fin_validite) . '</td>';
// print '<td>'.$obj->fk_societe.'</td>';
//print '<td><a href="../comm/fiche.php?socid='.$obj->fk_soc.'">'.img_object($langs->trans("ShowCompany"),"company").'prop '.$obj->nom.'</a></td>';
//print '<td>'.$obj->fk_user_mod.'</td>';
//print '<td><a href="../comm/fiche.php?socid='.$obj->fk_user_mod.'">'.img_object($langs->trans("ShowCompany"),"company").' loc'.$obj->nom.'</a></td>';
//print '<td>'.$obj->fk_societe.'</td>';
//print '</td></tr>';
}
$i++;
}
}
} else {
