function getStateName($value) { $q = "SELECT * FROM state WHERE state_id = '$value'"; $result = mysql_query($q); /* Error occurred, return given name by default */ if(!$result || (mysql_num_rows($result) < 1)){ return NULL; } /* Return result array */ $dbarray = mysql_fetch_array($result); return $dbarray['state']; } function getDistrictName($value) { $q = "SELECT * FROM areas WHERE district_code = '$value' AND district_name!=''"; $result = mysql_query($q); /* Error occurred, return given name by default */ if(!$result || (mysql_num_rows($result) < 1)){ return NULL; } /* Return result array */ $dbarray = mysql_fetch_array($result); return $dbarray['district_name']; } function getLocalityName($value,$district) { $q = "SELECT * FROM areas WHERE district_code = '$district' AND block_code = '$value' AND block_name!=''"; $result = mysql_query($q); /* Error occurred, return given name by default */ if(!$result || (mysql_num_rows($result) < 1)){ return NULL; } /* Return result array */ $dbarray = mysql_fetch_array($result); return $dbarray['block_name']; } function getVillageName($value) { $q = "SELECT * FROM areas WHERE prime_id = '$value'"; $result = mysql_query($q); /* Error occurred, return given name by default */ if(!$result || (mysql_num_rows($result) < 1)){ return NULL; } /* Return result array */ $dbarray = mysql_fetch_array($result); return $dbarray['village_name']; } function getGodCategoryName($value) { $q = "SELECT * FROM god_common_name WHERE id = '$value'"; $result = mysql_query($q); /* Error occurred, return given name by default */ if(!$result || (mysql_num_rows($result) < 1)){ return NULL; } /* Return result array */ $dbarray = mysql_fetch_array($result); return $dbarray['god_name']; } function getTempleCategoryName($value) { $q = "SELECT * FROM temple_types WHERE type_id = '$value'"; $result = mysql_query($q); /* Error occurred, return given name by default */ if(!$result || (mysql_num_rows($result) < 1)){ return NULL; } /* Return result array */ $dbarray = mysql_fetch_array($result); return $dbarray['temple_type']; } function getDistrictsCount($value) { // $q = "SELECT COUNT(*) as count FROM areas WHERE state_code = '$value' AND district_name!=''"; $q = "SELECT COUNT(*) as count FROM areas GROUP BY `district_code`"; $result = mysql_query($q); /* Error occurred, return given name by default */ if(!$result || (mysql_num_rows($result) < 1)){ return 0; } /* Return result array */ $dbarray = mysql_fetch_array($result); return $dbarray['count']; } function isDistrictExist($value,$state) { $q = "SELECT COUNT(*) as count FROM areas WHERE state_code = '$state' AND district_name='$value'"; $result = mysql_query($q); /* Error occurred, return given name by default */ if(!$result || (mysql_num_rows($result) < 1)){ return 0; } /* Return result array */ $dbarray = mysql_fetch_array($result); return $dbarray['count']; } function getDistrictBlocksCount($state,$district) { $q = "SELECT COUNT(*) as count FROM areas WHERE state_code = '$state' AND district_code='$district' AND`block_name`!=''"; $result = mysql_query($q); /* Error occurred, return given name by default */ if(!$result || (mysql_num_rows($result) < 1)){ return 0; } /* Return result array */ $dbarray = mysql_fetch_array($result); return $dbarray['count']; } function isDistrictBlockExist($state,$district,$value) { $q = "SELECT COUNT(*) as count FROM areas WHERE state_code = '$state' AND district_code='$district' AND block_name='$value'"; $result = mysql_query($q); /* Error occurred, return given name by default */ if(!$result || (mysql_num_rows($result) < 1)){ return 0; } /* Return result array */ $dbarray = mysql_fetch_array($result); return $dbarray['count']; } function getBlockVillageCount($state,$district,$blocks) { $q = "SELECT COUNT(*) as count FROM areas WHERE state_code = '$state' AND district_code='$district' AND block_code='$blocks' GROUP BY `village_code`"; $result = mysql_query($q); /* Error occurred, return given name by default */ if(!$result || (mysql_num_rows($result) < 1)){ return 0; } /* Return result array */ $dbarray = mysql_fetch_array($result); return $dbarray['count']; } function isBlockVillageExist($state,$district,$blocks,$village) { $q = "SELECT COUNT(*) as count FROM areas WHERE state_code = '$state' AND district_code='$district' AND block_code='$blocks' AND village_name='$village'"; $result = mysql_query($q); /* Error occurred, return given name by default */ if(!$result || (mysql_num_rows($result) < 1)){ return 0; } /* Return result array */ $dbarray = mysql_fetch_array($result); return $dbarray['count']; } ?>