From f926f2b8b1a793ba0f5fab44d5080da45522932c Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Wed, 10 Dec 2008 19:23:44 +0100 Subject: [PATCH] Adapts mentoring to the new sectors. --- modules/profile.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/modules/profile.php b/modules/profile.php index da843b8..293f3a6 100644 --- a/modules/profile.php +++ b/modules/profile.php @@ -612,7 +612,7 @@ class ProfileModule extends PLModule //secteurs $secteurs = $ss_secteurs = Array(); $res = XDB::iterRow( - "SELECT s.label, ss.label + "SELECT s.name AS label, ss.name AS label FROM profile_mentor_sector AS m LEFT JOIN profile_job_sector_enum AS s ON(m.sectorid = s.id) LEFT JOIN profile_job_subsector_enum AS ss ON(m.sectorid = ss.sectorid AND m.subsectorid = ss.id) -- 2.1.4