runQuery("SELECT * FROM (((asset_item
INNER JOIN asset ON asset_item.asset_id = asset.asset_id)
INNER JOIN asset_item_location ON asset_item.asset_item_id = asset_item_location.asset_item_id)
INNER JOIN location ON asset_item_location.location_id = location.location_id)
WHERE asset_item.asset_no = '$id' AND asset_item_location.is_active = 'yes'");
$i =1;
foreach($chgrp as $result){
$asset_no = $result['asset_no'];
$asset_description = $result['asset_description'];
$asset_name = $result['asset_name'];
$longitude = $result['longitude'];
$latitude = $result['latitude'];
$room_no = $result['room_no'];
$location_name = $result['location_name'];
$floor = $result['floor'];
$building = $result['building'];
}
?>
Properties of UIET :
Asset No.:
Description:
Asset Name:
Location:
Longitude:
Lattitude: