search result display help

hello,

i have made a page to display the result of a search, how ever i couldn't do it as i wanted

here is a link of how i want it: http://www.arencore.com/property.php

i will post the code i did and screen shot of the page and db info for help

and for retrieving the image, the name of the image is saved in db (imageinfo field) and it's always uploaded to uploaded_images/

so i did this code for retrieving it:

echo '<img width="159" height="113" src="uploaded_Images/';  
      echo $row['imageinfo'] . '" alt="' . $row['imageinfo'];
echo '"/></a>

<?php require_once("includes/connection.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php include("includes/header.php"); ?>
 
		<td id="page">
			<h2>Welcome to Coordination Real Estate</h2>
			<script type="text/javascript" src="javascript/container_core-min.js"></script> 
	<script type="text/javascript" src="javascript/carousel.js"></script>
 
	<link rel="stylesheet" type="text/css" href="stylesheets/base-min.css">
	<link href="stylesheets/carousel.css" rel="stylesheet" type="text/css">
	<link href="stylesheets/yui.css" rel="stylesheet" type="text/css">
 
<?php
 
		
	 $listedPrice = $_POST['listedPrice'];
        $No_bedroom = $_POST['No_bedroom'];
        $PropertyCountry = $_POST['country'];
        $PropertyCity = $_POST['cityList'];
        $PropertyType = $_POST['PropertyType'];
        $NO_bathroom = $_POST['NO_bathroom'];
 
$listtemp = explode("-", $listedPrice,2);
 
$query = "SELECT * from properties WHERE 
  listedPrice between  {$listtemp[0]} AND {$listtemp[1]} AND
  No_bedroom = $No_bedroom AND 
  PropertyCountry = '$PropertyCountry' AND 
  PropertyCity = '$PropertyCity' AND 
  PropertyType = $PropertyType AND 
  NO_bathroom = $NO_bathroom 
LIMIT 0,10;";
 
 
$query2 = mysql_query($query);
if(!$query2) die('SQL error: '.mysql_error());
 
echo '<table>';
 
while ($row = mysql_fetch_array($query2)) {
 
 
// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['Propertyid'];
echo "</td><td>";
if ( $row['PropertyType'] == 1 ) {
	echo "Apratment"; } else {
		echo "Villa"; }
echo "</td><td>";
echo $row['PropertyAddress']; 
echo "</td><td>";
echo $row['No_bedroom'];
echo "</td><td>";
echo $row['ListingDate'];
echo "</td><td>";
echo $row['ListedPrice'];
echo "</td><td>";
echo $row['DateBuild'];
echo "</td><td>";
echo $row['Area'];
echo "</td><td>";
echo $row['Description'];
echo "</td></tr>";
}
echo "</table>";
 
	
 
?>
		</td>
	</tr>
</table>
<?php require("includes/footer.php"); ?>

Select allOpen in new window

db.jpg
result.jpg