So you just completed setting up osCommerce store, and while testing and creating the new account as customer, your client just does not want the unending countries list in the dropdown select field, and more often than not, most clients are only focusing on one country anyway, you can accomplish this in two ways.
First is the old school way, go to the admin panel, and delete countries one by one, or using phpMyAdmin or SQLyog, just truncate the ‘countries’ table and insert your required country/countires.
There’s another smart way, add another column(field) int type with the name ‘active’ in the ‘countries’ table. Mark all those countries to ‘1’ which you want in the drop down.
Now open this file catalog/includes/functions/general.php and make changes in the function named ‘tep_get_countries’
Find following code around line 190:
$countries = tep_db_query("select countries_id, countries_name from " . TABLE_COUNTRIES . " order by countries_name");
Replace with this code:
$countries = tep_db_query("select countries_id, countries_name from " . TABLE_COUNTRIES . " WHERE active='1' ORDER BY countries_name");
Hope that would restrict your country dropdown list.