Adding a new country in the country list ?

[amr.khusheim]

guys i searched on the forum and the contributions but i didnt find a solution to do this

 

how do you add a country to make it appear in the account creation process ??

for example i want to add a country that is not in the country list .. for example lets say "country1"

how do i do it ?

 

i read about removing and deleting countries but i cant find information about adding

 

please help me on this one

well appreciated

[BryceJr]

guys i searched on the forum and the contributions but i didnt find a solution to do this

 

how do you add a country to make it appear in the account creation process ??

for example i want to add a country that is not in the country list .. for example lets say "country1"

how do i do it ?

 

i read about removing and deleting countries but i cant find information about adding

 

please help me on this one

well appreciated

Look inside the install folder. You'll find oscommerce.sql

Open it.

Browse down to the countries table. Use that as referrence to what the columns are referring to.

 

Scroll down a little bit more and look for INSERT INTO countries VALUES (...

Those are the sql (insert) statements used by oscommerce to insert different countries to the countries table.

 

If you know your values (referring to countries table), you can use that and run that in the query window (PhpMyAdmin).

 

I suggest that you insert your own country after Zimbabwe.

[amr.khusheim]

Thank you very much Bryce

 

I tried what you said and i got this msg

 

SQL query:

 

INSERT INTO countries

VALUES ( 240, 'North Cyprus', 'NC', 'RNC', '1' )

 

MySQL said: Documentation

#1136 - Column count doesn't match value count at row 1

 

I placed it right after Zimbabwe as you said

 

Did i miss something ?

Thanks again :)

[amr.khusheim]

thanks i did it

 

for those who might be in my place one day

 

just use phpmyadmin and choose the countries table and add it manually

 

it works !

 

thanks again bryce