PAGINA DOVE FACCIO LA RICERCA :
---------------------------------------------------------
<form name="form1" method="get" action="usato1.php">
<font face="arial, verdana" color="#003333" size="2">Seleziona Marca:</font>

<select name="parola" type="text" id="parola">
<option value="">MARCA</option>
<option value="83">Alfa Romeo</option>
<option value="161">Audi</option>
<option value="85">BMW</option>
<option value="87">Chrysler</option>
<option value="91">Citroen</option>
<option value="577">Daewoo</option>
<option value="13">Ferrari</option>
<option value="8">Fiat</option>
<option value="39">Ford</option>
<option value="147">Honda</option>
<option value="122">Hyndai</option>
<option value="110">Jaguar</option>
<option value="144">Jeep</option>
<option value="746">KIA</option>
<option value="34">Lancia</option>
<option value="140">Land Rover</option>
<option value="145">Mazda</option>
<option value="33">Mercedes Benz</option>
<option value="2222">Mini</option>
<option value="148">Mitsubishi</option>
<option value="149">Nissan</option>
<option value="20">Opel</option>
<option value="151">Peugeout</option>
<option value="27">Porsche</option>
<option value="62">Renault</option>
<option value="154">Rover</option>
<option value="153">Saab</option>
<option value="2259">Smart</option>
<option value="103">Toyota</option>
<option value="101">Volkswagen</option>
<option value="98">Volvo</option></SELECT>
<input type="submit" name="Submit" value="Cerca"></form>
--------------------------------------------------------------------
USATO1.PHP
-------------------------------------------------------------------
<?PHP




$word=trim($_GET['parola']);
$conn=odbc_connect("usato",'','') or die(odbc_error());
$query="SELECT * FROM usato where lCODMAR like '%$word%'";
$res=odbc_exec($conn,$query) or die (odbc_error());
while (odbc_fetch_row($res)) {

$codice=odbc_result($res,'lCODMAR');
$id=odbc_result($res,'dDATIMM');
$nome=odbc_result($res,'SMMA');
$cognome=odbc_result($res,'lKMPERCI');
$rep=odbc_result($res,'dbPREVENE');
$prezzo_number = number_format($rep, 2, ',', '');

echo '<table cellspacing="0" cellpadding="0" align=center width=100% height=170 valign=top>';
echo '<tr>';
echo '<td valign=middle align=center width=70% height=170 background="sottodesc.jpg">';
print "Data immatricolazione = $id
";
print "cODICE mARCA = $codice
";
print "<font face=arial, verdana color=#003366 size=3>$nome</font>
";
print "Km = $cognome

";
print "<div align=right><font face=arial, verdana color=#003366 size=2>€.$prezzo_number</font> </div>
";





$foto=odbc_result($res,'sFOTO1');
echo '<td valign=middle align=center width=30% height=170 background="sottogif.jpg">';
print "<img src=$foto width=220 height=160>";
echo '</td>';
echo '</tr>';
}
odbc_close($conn);


?>
--------------------------------------------------------------------
FACENDO COSì MI RICACCIA OVVIAMENTE I RECORDSET A SECONDO DELLA MARCA CHE SELEZIONO..ma prima di questo vorrei ke uscisse in una select solo la dscrizione dell'auto "$nome"
possibilmente nella pagina di ricerca..
grazie dell'aiuto..