* *
* -------------------------------------------------------------------- *
* File : country_functions.php *
* *
* -------------------------------------------------------------------- *
* File : country_functions.php *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
// Generate a human-readable country description with code
function generateCountryInfo ($id) {
// Not found is the default
// Generate a human-readable country description with code
function generateCountryInfo ($id) {
// Not found is the default
- $result = SQL_QUERY_ESC("SELECT `code`, `descr` FROM `{?_MYSQL_PREFIX?}_countries` WHERE `id`=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `code`,`descr` FROM `{?_MYSQL_PREFIX?}_countries` WHERE `id`=%s LIMIT 1",
array(bigintval($id)), __FUNCTION__, __LINE__);
// Is there an entry?
if (SQL_NUMROWS($result) == 1) {
// Load entry
$content = SQL_FETCHARRAY($result);
array(bigintval($id)), __FUNCTION__, __LINE__);
// Is there an entry?
if (SQL_NUMROWS($result) == 1) {
// Load entry
$content = SQL_FETCHARRAY($result);
// Construct human-readable description
$ret = sprintf("%s (%s)", $content['descr'], $content['code']);
// Construct human-readable description
$ret = sprintf("%s (%s)", $content['descr'], $content['code']);