Region Explorer


Original Owner:
Current Owner:
Resource Type:
Resource:
0 && $currentowner <> 0) { $query = $query."a.originalownerid = ".$originalowner." and a.currentownerid = ".$currentowner." and "; } else { if ($originalowner <> 0) { $query = $query."a.originalownerid = ".$originalowner." and "; } if ($currentowner <> 0) { $query = $query."a.currentownerid = ".$currentowner." and "; } } if ($resourcetype <> "All") { $query = $query."d.type = '".$resourcetype."' and "; } if ($resource <> "All") { $query = $query."d.name = '".$resource."' and "; } $query = $query."a.resourceid = d.resourceid and a.originalownerid = b.countryid and a.currentownerid = c.countryid and a.hospitalid = e.hospitalid and a.defensesystemid = f.defensesystemid and a.regiontypeid = g.regiontypeid order by a.currentownerid, a.originalownerid"; $result = mysql_query($query); while ($row = mysql_fetch_array($result)) { echo ""; if ($row["airbase"] == 0) { echo ""; } else { echo ""; } echo ""; } mysql_free_result($result); ?>
Region IDRegionRegion TypeResource TypeResourceOriginal OwnerCurrent OwnerHospitalDefense SystemAirbaseLast Update
".$row['regionid']."".$row['name']."".$row['regiontype']."".$row['type']."".$row['resource']."".$row['originalowner']."".$row['currentowner']."".$row['hospital']."".$row['defensesystem']."NoYes".$row['lastupdate']."