X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=sidebyside;f=include%2Fprofil.func.inc.php;h=10b34162a2fe6cff5fc264c0d9142e8029b62175;hb=f57e5fa87ecd2af3e658e126a626a1afbf37414e;hp=24d5b7e58727dc265b0ac09bfa9fb42f7bf602e9;hpb=7706cc73e140d7a154136cf1e6836091a25c69c5;p=platal.git diff --git a/include/profil.func.inc.php b/include/profil.func.inc.php index 24d5b7e..10b3416 100644 --- a/include/profil.func.inc.php +++ b/include/profil.func.inc.php @@ -1,6 +1,6 @@ '','phon $ret = ''; $tel_length = strlen($tel); if((!isset($format['phoneprf'])) || ($format['phoneprf'] == '')) { - $res = XDB::query("SELECT phoneprf, phoneformat AS format - FROM geoloc_pays - WHERE phoneprf = {?} OR phoneprf = {?} OR phoneprf = {?} + $res = XDB::query("SELECT phonePrefix AS phoneprf, phoneFormat AS format + FROM geoloc_countries + WHERE phonePrefix = {?} OR phonePrefix = {?} OR phonePrefix = {?} LIMIT 1", substr($tel, 0, 1), substr($tel, 0, 2), substr($tel, 0, 3)); if ($res->numRows() == 0) {