echo "primo<select name=\"select1\" size=\"5\">";
$db = mysql_connect($db_host, $db_user, $db_password);
if ($db == FALSE)
die ("");
mysql_select_db($db_name, $db)
or die ("");
$a = $_POST['aaa'];
$query = "SELECT * FROM tabella WHERE categoria LIKE '%$a%'";
$result = mysql_query($query, $db);
while ($row = mysql_fetch_array($result))
{
echo "<option value=\"".$row[0]."\">".$row[3]." ".$row[9]."</option>";
}
mysql_free_result($result);
mysql_close($db);
echo "secondo<select name=\"select2\" size=\"5\">";
$db = mysql_connect($db_host, $db_user, $db_password);
if ($db == FALSE)
die ("");
mysql_select_db($db_name, $db)
or die ("");
$b = $_POST['bbb'];
$query = "SELECT * FROM tabella WHERE categoria LIKE '%$b%'";
$result = mysql_query($query, $db);
while ($row = mysql_fetch_array($result))
{
echo "<option value=\"".$row[0]."\">".$row[3]." ".$row[9]."</option>";
}
mysql_free_result($result);
mysql_close($db);
....
ecc ... ecc...