Updates geoloc_* tables and adds official languages to countries.

[platal.git] / include / education.func.inc.php

diff --git a/include/education.func.inc.php b/include/education.func.inc.php
index dbfba28..51437db 100644 (file)
--- a/include/education.func.inc.php
+++ b/include/education.func.inc.php
@@ -22,14 +22,14 @@
 function education_options($current = 0)
 {
     $html = '<option value="-1">&nbsp;</option>';
-    $res  = XDB::iterator("SELECT  e.id AS id, gc.countryFR AS country,
+    $res  = XDB::iterator("SELECT  e.id AS id, gc.country,
                                    IF(CHAR_LENGTH(e.name) > 76, e.abbreviation, e.name) AS name
                              FROM  profile_education_enum AS e
                         LEFT JOIN  geoloc_countries       AS gc ON (e.country = gc.iso_3166_1_a2)
                      WHERE EXISTS  (SELECT  *
                                       FROM  profile_education_degree AS d
                                      WHERE  e.id = d.eduid)
-                         ORDER BY  gc.countryFR, e.name");
+                         ORDER BY  gc.country, e.name");
     $country = "";
     while ($arr_edu = $res->next()) {
         if ($arr_edu["country"] != $country) {