triplelatte Posted April 27, 2005 Posted April 27, 2005 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!
H2B2 Posted April 27, 2005 Posted April 27, 2005 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? :'( <{POST_SNAPBACK}> 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
RussellT Posted April 28, 2005 Posted April 28, 2005 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 <{POST_SNAPBACK}> 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.