<?php

function print_debug(&$Value, $Info='<b>debug</b>')
{
    echo "<pre><font size=\"2\">_______________________________".$Info."_____________________________________\n";
    print_r($Value);
    echo "____________________________________________________________________</font></pre>\n";
}

function GetCountry(&$db, $ID)
{
    $sql = 'SELECT  country_name '
          .'FROM '.DB_PREFIX.'_countries '
          .'WHERE country_id = '.$ID;
    $result = $db->select($sql);
    return $result[0]['country_name'];
}

function GetAllCountries(&$db)
{
    $sql = 'SELECT  country_id, country_name '
          .'FROM '.DB_PREFIX.'_countries '
          .'ORDER BY country_name ';
    $result = $db->select($sql);
    return $result;
}

function GetWhere(&$db, $ID)
{
    $sql = 'SELECT  where_id, where_name '
          .'FROM '.DB_PREFIX.'_where '
          .'WHERE where_id = '.$ID;
    $result = $db->select($sql);
    return $result[0];
}

function GetAllWhere(&$db)
{
    $sql = 'SELECT  where_id, where_name '
          .'FROM '.DB_PREFIX.'_where ';
//          .'ORDER BY where_name ';
    $result = $db->select($sql);
    return $result;
}

function get_states()
{
    return array(
    'AL' => 'Alabama',
    'AK' => 'Alaska',
    'AZ' => 'Arizona',
    'AR' => 'Arkansas',
    'CA' => 'California',
    'CO' => 'Colorado',
    'CT' => 'Connecticut',
    'DE' => 'Delaware',
    'DC' => 'District of Columbia',
    'FL' => 'Florida',
    'GA' => 'Georgia',
    'HI' => 'Hawaii',
    'ID' => 'Idaho',
    'IL' => 'Illinois',
    'IN' => 'Indiana',
    'IA' => 'Iowa',
    'KS' => 'Kansas',
    'KY' => 'Kentucky',
    'LA' => 'Louisiana',
    'ME' => 'Maine',
    'MD' => 'Maryland',
    'MA' => 'Massachusetts',
    'MI' => 'Michigan',
    'MN' => 'Minnesota',
    'MS' => 'Mississippi',
    'MO' => 'Missouri',
    'MT' => 'Montana',
    'NE' => 'Nebraska',
    'NV' => 'Nevada',
    'NH' => 'New Hampshire',
    'NJ' => 'New Jersey',
    'NM' => 'New Mexico',
    'NY' => 'New York',
    'NC' => 'North Carolina',
    'ND' => 'North Dakota',
    'OH' => 'Ohio',
    'OK' => 'Oklahoma',
    'OR' => 'Oregon',
    'PA' => 'Pennsylvania',
    'RI' => 'Rhode Island',
    'SC' => 'South Carolina',
    'SD' => 'South Dakota',
    'TN' => 'Tennessee',
    'TX' => 'Texas',
    'UT' => 'Utah',
    'VT' => 'Vermont',
    'VI' => 'Virgin Islands',
    'VA' => 'Virginia',
    'WA' => 'Washington',
    'WV' => 'West Virginia',
    'WI' => 'Wisconsin',
    'WY' => 'Wyoming');
}

?>