public static function getPicCityTourByLocation($location_id) { $db = new Application_Model_DbTable_DbFrontend(); $sql = " SELECT pic_title FROM `ldc_picture_location` WHERE location_id={$location_id} AND STATUS=1 AND pic_title!='' ORDER BY id ASC LIMIT 1"; return $db->getGlobalDbRow($sql); }