From 33b6f5a0072343de978e05f855739322b94179e5 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Sat, 6 Dec 2008 23:52:50 +0100 Subject: [PATCH] Fixes sector and function's display in the profile edition interface. --- modules/profile/jobs.inc.php | 12 +++++++----- 1 file changed, 7 insertions(+), 5 deletions(-) diff --git a/modules/profile/jobs.inc.php b/modules/profile/jobs.inc.php index 5d95ae4..7983f8f 100644 --- a/modules/profile/jobs.inc.php +++ b/modules/profile/jobs.inc.php @@ -295,11 +295,13 @@ class ProfileJobs extends ProfilePage require_once "emails.combobox.inc.php"; fill_email_combobox($page); - $page->assign('secteurs', XDB::iterator("SELECT id, name AS label - FROM profile_job_sector_enum")); - $page->assign('fonctions', XDB::iterator("SELECT id, fonction_fr, FIND_IN_SET('titre', flags) AS title - FROM fonctions_def - ORDER BY id")); + $res = XDB::query("SELECT id, name AS label + FROM profile_job_sector_enum"); + $page->assign('secteurs', $res->fetchAllAssoc()); + $res = XDB::query("SELECT id, fonction_fr, FIND_IN_SET('titre', flags) AS title + FROM fonctions_def + ORDER BY id"); + $page->assign('fonctions', $res->fetchAllAssoc()); $res = XDB::iterator("SELECT id, name FROM profile_corps_enum -- 2.1.4