From 0abd0cea70b22676ae32ad04b7bd98e9f7ea4733 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Mon, 2 Mar 2009 23:06:51 +0100 Subject: [PATCH] Fixes education degree edition. --- include/education.func.inc.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/include/education.func.inc.php b/include/education.func.inc.php index 68ec9b7..8bc691c 100644 --- a/include/education.func.inc.php +++ b/include/education.func.inc.php @@ -64,7 +64,7 @@ function education_degree() $res = XDB::iterRow("SELECT d.eduid, d.degreeid FROM profile_education_enum AS e INNER JOIN profile_education_degree AS d ON (e.id = d.eduid) - LEFT JOIN geoloc_countries AS gc ON (e.country = gc.a2) + INNER JOIN geoloc_countries AS gc ON (e.country = gc.iso_3166_1_a2) ORDER BY gc.countryFR, e.name"); if ($edu_degree = $res->next()) { $eduid = $edu_degree['0']; -- 2.1.4