$query="select UnitBlockName,UnitName,ifnull(TenantName,'Available') as vTenant,PropWebsiteDisplayBlockName from Unit A";
$query=$query." join UnitBlock B on A.UnitBlockUId=B.UnitBlockUID";
$query=$query." left join Lease C on (C.UnitUID=A.UnitUID and C.LeaseActive=0)";
$query=$query." left join Tenant D on D.TenantUID=C.TenantUID";
$query=$query." left join PropertyWebsite E on A.PropUID=E.webPropUID";
$query=$query." where A.PropUID=".$_GET['PUID'];
$query=$query." order by UnitBlockName,UnitName";
$result = $db->query($query);
if($result->num_rows>0) {
for($i=0; $i<$result->num_rows; $i++){
$row=$result->fetch_assoc();?>
Unit
if ($row['PropWebsiteDisplayBlockName']==1) {
echo $row['UnitBlockName']." ";
}
echo $row['UnitName'];
?>