X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=sidebyside;f=include%2Feducation.func.inc.php;h=cb25855f40a624b39fdff8f823a6cb0aeb6c2dce;hb=fb052bdeb13817b3dda3f7443fe7b2717b7413ca;hp=dd635915e99c7667de775a5d0f70858c20ed318d;hpb=c12cc82e1d97b51e19b294942ea9450a34d929cd;p=platal.git
diff --git a/include/education.func.inc.php b/include/education.func.inc.php
index dd63591..cb25855 100644
--- a/include/education.func.inc.php
+++ b/include/education.func.inc.php
@@ -1,6 +1,6 @@
';
- $res = XDB::iterator("SELECT e.id AS id, gc.countryFR AS country,
+ $html = '';
+ $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");
+ WHERE e.id = d.eduid) AND e.name != {?}
+ ORDER BY gc.country, e.name",
+ Profile::EDU_X);
$country = "";
while ($arr_edu = $res->next()) {
if ($arr_edu["country"] != $country) {
+ if ($country) {
+ $html .= '';
+ }
$country = $arr_edu["country"];
- $html .= "