<form name="ricerca" method="get" action="">
<TABLE>
<TR>
<TD>
<INPUT TYPE="TEXT" NAME="search_name"></P>
</TD>
<TD>
<SELECT NAME="search_societa">
<?php
echo "<OPTION>";
$query="select societa from societa order by societa";
$db->select_db('one');
$result=$db->query($query);
if (!$result) {
echo "<OPTION>DB Error, could not query the database";
}
$num_rows=$result->num_rows;
for($i=0;$i<$num_rows;$i++)
{
$row=$result->fetch_row();
echo "<OPTION>$row[0]</OPTION>";
}
?>
</SELECT>
</TD>
<TD>
<SELECT NAME="search_ufficio">
<?php
echo "<OPTION>";
$query="select ufficio from ufficio order by ufficio";
$db->select_db('one');
$result=$db->query($query);
if (!$result) {
echo "<OPTION>DB Error, could not query the database";
}
$num_rows=$result->num_rows;
for($i=0;$i<$num_rows;$i++)
{
$row=$result->fetch_row();
echo "<OPTION>$row[0]</OPTION>";
}
?>
</SELECT>
</TD>
<TD>
<INPUT type="submit" name="search" value="Ricerca">
</TD>
</TR>
</TABLE>