Country::GetNumCountries PHP Method

    public static function GetNumCountries($p_languageId = null, $p_code = null, $p_name = null)
    {
        global $g_ado_db;
        $queryStr = "SELECT COUNT(*) FROM Countries";
        $constraints = array();
        if (!is_null($p_languageId)) {
            $constraints[] = array('IdLanguage', $p_languageId);
        }
        if (!is_null($p_code)) {
            $constraints[] = array('Code', $p_code);
        }
        if (!is_null($p_name)) {
            $constraints[] = array('Name', $p_name);
        }
        if (count($constraints) > 0) {
            $tmpArray = array();
            foreach ($constraints as $constraint) {
                $tmpArray[] = $constraint[0] . "='" . $constraint[1] . "'";
            }
            $queryStr .= " WHERE " . implode(" AND ", $tmpArray);
        }
        $total = $g_ado_db->GetOne($queryStr);
        return $total;
    }

require_once $GLOBALS['g_campsiteDir'] . "/{$ADMIN_DIR}/country/country_common.php";
require_once $GLOBALS['g_campsiteDir'] . "/classes/SimplePager.php";
camp_load_translation_strings("api");
if (!$g_user->hasPermission('ManageCountries') && !$g_user->hasPermission('DeleteCountries')) {
    camp_html_goto_page("/{$ADMIN}/");
}
$f_country_language_selected = camp_session_get('f_country_language_selected', '');
$f_country_offset = camp_session_get('f_country_offset', 0);
if (empty($f_country_language_selected)) {
    $f_country_language_selected = null;
}
$ItemsPerPage = 20;
$languages = Language::GetLanguages(null, null, null, array(), array(), true);
$countries = Country::GetCountries($f_country_language_selected, null, null, array("LIMIT" => array("START" => $f_country_offset, "MAX_ROWS" => $ItemsPerPage)));
$numCountries = Country::GetNumCountries($f_country_language_selected);
$pager = new SimplePager($numCountries, $ItemsPerPage, "f_country_offset", "index.php?");
$crumbs = array();
$crumbs[] = array(getGS("Configure"), "");
$crumbs[] = array(getGS("Countries"), "");
echo camp_html_breadcrumbs($crumbs);
?>

<P>
<TABLE BORDER="0" CELLSPACING="0" CELLPADDING="3" class="action_buttons">
<?php 
if ($g_user->hasPermission("ManageCountries")) {
    ?>
<TR>
	<TD>
		<TABLE BORDER="0" CELLSPACING="0" CELLPADDING="1">