Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Removing Countries - Easy Way?


triplelatte

Recommended Posts

Posted

Is there an easy way to remove all of the countries except US and Canada without having to click on each one and delete/confirm from the Config panel? :'(

Thanks for your time!

Posted
Is there an easy way to remove all of the countries except US and Canada without having to click on each one and delete/confirm from the Config panel?  :'(

 

Found this in my notes to only leave the US.

 

In PHPMyAdmin, execute:

delete from countries where countries_id <> 223

 

BUT, you have to adapt it to leave Canada intact in your list too. I'm new to SQL, so can't say how this should be done.

 

Al

Posted
Found this in my notes to only leave the US.

 

In PHPMyAdmin, execute:

BUT, you have to adapt it to leave Canada intact in your list too. I'm new to SQL, so can't say how this should be done.

 

Al

 

If you have access to your server control panel, I have CPanel supplied by my host, then you should be able to access the tables via PHPAdmin. I selected all the countries to delete from the table countries, less the UK for my site.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...