?>
<form method="POST">
Ricerca : <input type="text" name="term" id="term" />

Ricerca2: <input type="text" name="term2" id="term2" />

<input type="submit" name="search" id="search" value="Search" />
</form>
<?
}elseif(isset($_POST['search'])){
$term = addslashes($_POST['term']);
$term2 = addslashes($_POST['term2']);
$search = mysql_query("SELECT * FROM `immobili` WHERE `Provincia` LIKE '%$term%' AND `Citta` LIKE '%$term2%'" );
$total = mysql_num_rows($search);
if($total == 0){
echo 'Nessun risultato ';
}else{
while($r = mysql_fetch_array($search)){
echo $r['Provincia'] ; echo $r['Citta'] ; echo $r['Zona'] ; echo $r['Tipologia'] ; echo $r['Mq'] ; echo $r['N° locali'] ; echo $r['Prezzo'] ; echo $r['Vendita'] ; echo $r['Affitto'] ; echo $r['Descrizione'] . '
';
} // End While.
} // End Else.
} // End ElseIf.
?>
</body>
</html>
<table width="100%" border="1">
<caption>
Risultati ricerca
</caption>
<tr>
<th scope="col">Provincia</th>
<th scope="col">Città</th>
<th scope="col">Zona</th>
<th scope="col">Tipologia</th>
<th scope="col">Mq</th>
<th scope="col">N° locali</th>
<th scope="col">Prezzo</th>
<th scope="col">Vendita</th>
<th scope="col">Affitto</th>
<th scope="col">Descrizione</th>
<th scope="col"></th>
</tr>
<tr>
<td>$r['Provincia']</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</table>