- $result = SQL_QUERY("SELECT id, code, descr, is_active FROM `{!_MYSQL_PREFIX!}_countries` ORDER BY code", __FILE__, __LINE__);
- if (SQL_NUMROWS($result) > 0) {
- // List all countries
- $OUT = ""; $SW = 2;
- while ($content = SQL_FETCHARRAY($result)) {
- // Prepare array for the template
- // @TODO Rewritings: name->descr,status->is_active in template
- $content = array(
- 'id' => $content['id'],
- 'code' => $content['code'],
- 'name' => $content['descr'],
- 'active' => TRANSLATE_YESNO($content['is_active']),
- 'sw' => $SW,
- 'status' => $content['is_active'],
- );
+ $result = sqlQuery('SELECT `id`, `code`, `descr`, `is_active` FROM `{?_MYSQL_PREFIX?}_countries` ORDER BY `code` ASC',
+ __FILE__, __LINE__);