لو ممكن سكربت البحث

<table width="40%" border="0" cellspacing="4" cellpadding="4" align="center">
<tr>
<td align="center">
<h4>Search</h4>
</td>
</tr>
<tr>
<td align="center"><input name="flatnumber" type="text" /></td>
</tr>
<tr>
<td align="center"><input name="submit" type="submit" value="Submit" /></td>
</tr>
</table>
</form>

 <form name="search3" action="search.php" method="post">

$flatnumber='NO data sent';
$db=mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('company');


echo'<table width="670" border="1" cellspacing="0" cellpadding="0" align="center">';
echo'<tr bgcolor="#0090A8">';
echo'<td align="center" class="tableheader">ID</td>';
echo'<td align="center" bgcolor="#0090A8" class="tableheader">Flat Number</td>';
echo'<td align="center" class="tableheader">Reserved</td>';
echo'</tr>';

/*additional data checking and striping*/
$result=mysql_query("SELECT * FROM flats WHERE flatnumber='{$_POST['flatnumber']}'",$db) or die(mysql_error());

/*If there is a matching row*/

if(mysql_num_rows($result) > 0)
{
//يتم هنا عرض البيانات كلها ب while
while($row=mysql_fetch_array($result))
{
$ID = $row['ID'];
$reserv = $row['reserv'];
$flatnumber=$row['flatnumber'];


echo '<tr>';
echo '<td align=center>' .$ID. '</td>';
echo '<td align=center> ' .$flatnumber. '</td>';
echo '<td align=center>' .$reserv. '</td>';
echo "</tr>";


//you may echo the data anywhere in the file
}

echo'</table>';

}

else
{
$flatnumber2= 'this is flat not exist';
echo '<div align="center"><font size="5" color="red">'.$flatnumber2.'</font></div>';
}
mysql_free_result($result);
mysql_close($db);
?>

 <?php