X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fprofile.php;h=7ef48adf1d8705a6ff5ac4d0b358cfa3884d6d03;hb=daa66175c727af26bbf0082a54d1f2048f405527;hp=7a52138f461f088f6f9a004beb07451111143248;hpb=a0c034efcf0777541e087500e94853f515cda1ca;p=platal.git

diff --git a/modules/profile.php b/modules/profile.php
index 7a52138..7ef48ad 100644
--- a/modules/profile.php
+++ b/modules/profile.php
@@ -429,11 +429,13 @@ class ProfileModule extends PLModule
         $page->assign('i', $id);
         $page->assign('job', array());
         $page->assign('new', true);
-        $page->assign('secteurs', XDB::iterator("SELECT  id, label
-                                                   FROM  emploi_secteur"));
-        $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, label
+                             FROM  emploi_secteur");
+        $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());
     }
 
     function handler_ajax_secteur(&$page, $id, $sect, $ssect = -1)