Adding Counties to Dropdown box

[kdipaolo]

Hi. I wanted to only have canada and USA as options for ordering a product so I used the SQL :

DELETE from countries WHERE countries_iso_code_3 NOT IN('CAN','US');

Unfortunatly, It only kept Canada and USA is not there.

Does anyone know how to add United States back on the list?

Thanks

[Ajeh]

You should be able to run the SQL command:

INSERT INTO countries VALUES (223,'United States','US','USA', '2');

[kdipaolo]

i love you