<?php
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
?>
<html>
<head>
</head>
<body>
<div>
<table border="0">
<thead>
<tr>
<th>PHOTO OF PROPERTY</th>
<th>ABOUT PROPERTY</th>
</tr>
</thead>
<tbody>
<?php
$query="SELECT *,states.statename,city.cityname,property_owner.name as oname,property_type.p_type from property_registration join states on states.stateid=property_registration.state_id join city on city.cityid=property_registration.city_id join property_type on property_type.p_id=property_registration.p_type join property_owner on property_registration.p_owner=property_owner.owner_id";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<tr>";
echo"<td><img src='properties\'".$row['photo']." width='200px' height='200px' alt='Sorry image cannot be displayed'/>
</td>";
echo"<td><span>OWNER NAME:".$row['oname']."</span><br/>
<span>PROPERTY ADDRESS:".$row['p_address']."</span><br/>
<span>STATE:".$row['statename']."</span><br/>
<span>CITY:".$row['cityname']."</span><br/>
<span>PROPERTY FOR:".$row['p_type']."</span><br/>
<span>CONTACT NO:".$row['contact']."</span><br/></td>";
echo"</tr>";
}
?>
</tbody>
</table>
</div>
</body>
</html>
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
?>
<html>
<head>
</head>
<body>
<div>
<table border="0">
<thead>
<tr>
<th>PHOTO OF PROPERTY</th>
<th>ABOUT PROPERTY</th>
</tr>
</thead>
<tbody>
<?php
$query="SELECT *,states.statename,city.cityname,property_owner.name as oname,property_type.p_type from property_registration join states on states.stateid=property_registration.state_id join city on city.cityid=property_registration.city_id join property_type on property_type.p_id=property_registration.p_type join property_owner on property_registration.p_owner=property_owner.owner_id";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<tr>";
echo"<td><img src='properties\'".$row['photo']." width='200px' height='200px' alt='Sorry image cannot be displayed'/>
</td>";
echo"<td><span>OWNER NAME:".$row['oname']."</span><br/>
<span>PROPERTY ADDRESS:".$row['p_address']."</span><br/>
<span>STATE:".$row['statename']."</span><br/>
<span>CITY:".$row['cityname']."</span><br/>
<span>PROPERTY FOR:".$row['p_type']."</span><br/>
<span>CONTACT NO:".$row['contact']."</span><br/></td>";
echo"</tr>";
}
?>
</tbody>
</table>
</div>
</body>
</html>
0 comments:
Post a Comment