- $res = XDB::iterRow("SELECT m.sectorid, m.subsectorid, ss.name
- FROM profile_mentor_sector AS m
- INNER JOIN profile_job_sector_enum AS s ON (m.sectorid = s.id)
- INNER JOIN profile_job_subsector_enum AS ss ON (s.id = ss.sectorid AND m.subsectorid = ss.id)
- WHERE m.uid = {?}",
- S::i('uid'));
- while (list($s, $ss, $ssname) = $res->next()) {
- if (!isset($value[$s])) {
- $value[$s] = array($ss => $ssname);
- } else {
- $value[$s][$ss] = $ssname;
- }
- }
- } else if (!is_array($value)) {
+ $res = XDB::query('SELECT e.jtid, e.full_name
+ FROM profile_mentor_term AS m
+ INNER JOIN profile_job_term_enum AS e ON (m.jtid = e.jtid)
+ WHERE m.pid = {?}',
+ $page->pid());
+ $value = $res->fetchAllAssoc();
+ } elseif (!is_array($value)) {