If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / Adding Counties to Dropdown box

Adding Counties to Dropdown box

Started by kdipaolo on 16 Jan 2012, 4:00 PM · Views: 410

Results 1 to 3 of 3
16 Jan 2012, 4:00 PM
#1
kdipaolo avatar

kdipaolo

New Zenner

Join Date:
Nov 2011
Posts:
81
Plugin Contributions:
0

Adding Counties to Dropdown box

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

16 Jan 2012, 4:09 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Adding Counties to Dropdown box

You should be able to run the SQL command:

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

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

16 Jan 2012, 4:15 PM
#3
kdipaolo avatar

kdipaolo

New Zenner

Join Date:
Nov 2011
Posts:
81
Plugin Contributions:
0

Re: Adding Counties to Dropdown box

i love you