search.php
----------------
<?php require_once('Connections/db.php'); ?>
<html>
<head>
<title>United Properties & Management -
Birmingham, West Midlands</title>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
<meta name="keywords" content="united properties
birmingham, west midlands, united, properties, management, to buy,
to let, mortgages, soho road, soho, estate agents, homes, houses,
commerical property">
<meta name="description" content="United Properties &
Management are located on 194 Soho Road, Birmingham, B21 9LR,
England. Tel: 0121 554 9000. The 1st Choice in property &
management">
<style type="text/css">
<!--
.style1 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
.style2 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
}
.style7 {font-size: 9px}
.style9 {font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px; font-weight: bold; }
.style12 {font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px; font-weight: bold; color: #FF0000; }
.style14 {font-size: 14}
.style15 {font-size: 14px}
.style16 {color: #FF0000;
font-weight: bold;
}
-->
</style>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0"
marginwidth="0" marginheight="0">
<!-- ImageReady Slices (mail2.psd) -->
<table width="753" height="578" border="0" align="center"
cellpadding="0" cellspacing="0" id="Table_01">
<tr>
<td height="107" colspan="3" valign="top">
<img src="images/top.jpg" width="752" height="107"
alt=""></td>
<td width="1">
<img src="images/spacer.gif" width="1" height="107"
alt=""></td>
</tr>
<tr>
<td height="38" colspan="3"><?php include
"navi2.php"; ?><td>
<img src="images/spacer.gif" width="1" height="6"
alt=""></td>
</tr>
<tr>
</tr>
<tr>
</tr>
<tr>
<td width="4" rowspan="2" valign="top"><p
class="style1"> </p>
</td>
</tr>
<tr>
<td width="744" valign="top"><table width="728"
height="31" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="723"><img src="images/to_buy.gif"
width="404" height="29"></td>
<td width="10"> </td>
</tr>
<tr>
<td valign="top"><div align="left"><?php
mysql_select_db($database_db, $db);
$PropType = $_GET['PropType'];
$NoBeds = $_GET['NoBeds'];
$City = $_GET['City'];
$maxPrice = $_GET['maxPrice'];
$query = "SELECT * FROM property WHERE B_R LIKE 'BUY' AND
Accepted LIKE 'YES' AND PropType LIKE '$PropType' AND NoBeds LIKE
'$NoBeds' And City LIKE '$City' AND Cost LIKE '<=$maxPrice'";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
echo "<p>Number of Properties Found:
".$num_results."</p>";
for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);
echo "<p><strong>" .($i+1)." . Address: ";
echo htmlspecialchars( stripslashes($row["Address"]));
echo "<p><strong>" .($i+1)." . Area: ";
echo htmlspecialchars( stripslashes($row["Area"]));
echo "<p><strong>" .($i+1)." . City: ";
echo htmlspecialchars( stripslashes($row["City"]));
echo "<p><strong>" .($i+1)." . Number of
Bedrooms: ";
echo htmlspecialchars( stripslashes($row["NoBeds"]));
echo "<p><strong>" .($i+1)." . Price £: ";
echo htmlspecialchars( stripslashes($row["Cost"]));
echo "</p>";
?> <br>
</div></td>
<td> </td>
</tr>
<tr>
<td><div align="center">
</div></td>
<td> </td>
</tr>
</table></td>
<td width="4">
<img src="images/spacer.gif" width="1" height="139"
alt=""></td>
</tr>
<tr>
<td colspan="3" background="images/menu.gif"><table
width="458" border="0" align="center" cellpadding="0"
cellspacing="0">
<tr>
<td> </td>
<td> </td>
<td><div align="center">
<table width="200" border="0" cellspacing="0"
cellpadding="0">
<tr>
<td width="17"><img
src="images/images/prop_list_01.gif" width="15"
height="15"></td>
<td width="43"><img
src="images/images/prop_list_02.gif" width="336"
height="15"></td>
<td width="31"><img
src="images/images/prop_list_03.gif" width="18"
height="15"></td>
</tr>
<tr>
<td
background="images/images/prop_list_04.gif"> </td>
<td bgcolor="#FFFFFF"><table width="200" border="0"
align="center" cellpadding="0" cellspacing="0" class="style2">
<tr>
<td><div align="center"><a
href="property.php?PropID=<? echo $row_Recordset1["PropID"];
?>"><img src="images/<?php echo
$row_Recordset1['Lrg_Image']; ?>" width="100" height="100"
border="0"></a></div></td>
<td><div align="center"></div></td>
<td><div align="center"><a
href="property.php?PropID=<? echo $row_Recordset1["PropID"];
?>"><img src="images/<?php echo
$row_Recordset1['Lrg_Image']; ?>" width="100" height="100"
border="0"></a></div></td>
</tr>
<tr>
<td><div align="center"><?php echo
$row_Recordset1['Area']; ?></div></td>
<td> </td>
<td><div align="center"><?php echo
$row_Recordset1['Area']; ?></div></td>
</tr>
<tr>
<td><div align="center" class="style16"><?php
echo $row_Recordset1['Cost']; ?></div></td>
<td> </td>
<td><div align="center" class="style16"><?php
echo $row_Recordset1['Cost']; ?></div></td>
</tr>
</table></td>
<td
background="images/images/prop_list_06.gif"> </td>
</tr>
<tr>
<td><img src="images/images/prop_list_07.gif"
width="15" height="16"></td>
<td><img src="images/images/prop_list_08.gif"
width="336" height="16"></td>
<td><img src="images/images/prop_list_09.gif"
width="18" height="16"></td>
</tr>
</table>
</div></td>
<td> </td>
<td> </td>
</tr>
</table></td>
<td>
<img src="images/spacer.gif" width="1" height="58"
alt=""></td>
</tr>
<tr>
<td colspan="3">
<img src="images/footer.gif" width="752" height="97"
alt=""></td>
<td>
<img src="images/spacer.gif" width="1" height="97"
alt=""></td>
</tr>
</table>
<!-- End ImageReady Slices -->
</body>
</html>
11
Replies
AdChoices