- $sql = "SELECT a2 AS id,IF(nat='',pays,nat) AS text FROM geoloc_pays ORDER BY text";
- $res = XDB::iterRow($sql);
+ $res = XDB::iterRow("SELECT iso_3166_1_a2 AS id, nationality AS text
+ FROM geoloc_countries
+ WHERE nationality IS NOT NULL
+ ORDER BY nationality");