From 095f01be1a359de8c175c8f6ac4bcc7eca5113df Mon Sep 17 00:00:00 2001 From: Florent Bruneau Date: Mon, 22 Oct 2007 20:25:18 +0200 Subject: [PATCH] Fix edition of non well geolocalized jobs Signed-off-by: Florent Bruneau --- modules/profile/jobs.inc.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/modules/profile/jobs.inc.php b/modules/profile/jobs.inc.php index 1ea4d5d..72f1919 100644 --- a/modules/profile/jobs.inc.php +++ b/modules/profile/jobs.inc.php @@ -152,7 +152,7 @@ class ProfileJobs extends ProfilePage e.adr_pub, e.tel_pub, e.email_pub, e.glat AS precise_lat, e.glng AS precise_lon FROM entreprises AS e - INNER JOIN geoloc_pays AS gp ON(gp.a2 = e.country) + LEFT JOIN geoloc_pays AS gp ON(gp.a2 = e.country) WHERE uid = {?} AND entreprise != '' ORDER BY entrid", S::i('uid')); $this->values['jobs'] = array(); -- 2.1.4