Q("select ELEID, ELENAME from PB_CVALUE_MST where VAID = '30' order by SORTNO") as $area) { $sql = "select SECID from PB_SECTION_TBL where SECSHOWFLG = '1' and EBAREA = '".$area['ELEID']."' order by SECSORTNO"; $city_list = $DBCON->Q($sql); if( count( $city_list ) > 0 ){ $thisList .= '

'.$area['ELENAME'].'

'; $thisNav .= '
  • '.$area['ELENAME'].'
  • '; $thisNav .= '
  • '.($SC->SECNAME).'
  • '."\n"; } if( count( $city_list ) > 0 ){ $thisList .= '
    支店・営業所名 電話番号 定休日 支店の物件
    '.($SC->SECNAME).' '.(($SC->FREETEL) ? $SC->FREETEL : $SC->TEL).' '.($SC->RHOLIDAY).' '.$thisBTN.'
    '.($SC->ADDRESS1).' '.($SC->ADDRESS2).'
    '; $thisNav .= ' '; } } echo '
    '.$tBreadCrumb.'
    '.$thisList.'
    '; include( BASE . "/common/include/footer.php"); ?>