Dakota Posted March 20, 2004 Share Posted March 20, 2004 In account creation, there is a huge drop down menu of countries. How do I just keep the US in there? Link to comment Share on other sites More sharing options...
Guest Posted March 20, 2004 Share Posted March 20, 2004 Delete the rest of them. Link to comment Share on other sites More sharing options...
Dakota Posted March 20, 2004 Author Share Posted March 20, 2004 Delete the rest of them. Ummm... that idea did cross my mind! Tell me where and how, please! Link to comment Share on other sites More sharing options...
Guest Posted March 20, 2004 Share Posted March 20, 2004 Either use phpmyadmin (available through your hosts control panel) to nuke them all in one shot or go the admin -> locations/taxes -> countries and nuke them one at a time. Link to comment Share on other sites More sharing options...
Dakota Posted March 20, 2004 Author Share Posted March 20, 2004 Looked at phpmyadmin and clicked on countries. There are 5 rows starting with countries_id. What should I delete? Link to comment Share on other sites More sharing options...
Nick1 Posted March 21, 2004 Share Posted March 21, 2004 I wanted to only sell to Canada...is there a faster way to delete countries? Also, I wil probably need to add more countries later when we expand thanks Link to comment Share on other sites More sharing options...
Dakota Posted March 22, 2004 Author Share Posted March 22, 2004 The best I have been able to do so far is to make the US the default country. It'll do for now. Link to comment Share on other sites More sharing options...
♥yesudo Posted March 22, 2004 Share Posted March 22, 2004 SQL - DELETE FROM 'countries' WHERE 'countries_id' != 'XXX'; where XXX is the id of the country you want to keep. Your online success is Paramount. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.