bigpedro Posted November 29, 2011 Share Posted November 29, 2011 Our customer wants us to add a new country under spain called spain canary islands. This will then fall into a different shipping zone. I've added the country no problem. However it always appears at the bottom of the list of countries on the registration form. We need it to appear just below spain. I know this should be easy but it is making my head hurt!! Any ideas?!?! Quote Link to comment Share on other sites More sharing options...
bigpedro Posted December 27, 2011 Author Share Posted December 27, 2011 Any ideas on this? It still appears under Zimbabwe at the bottom. Help!! Quote Link to comment Share on other sites More sharing options...
bsmither Posted December 27, 2011 Share Posted December 27, 2011 Two ways to fix this: massage the data in the CubeCart_iso_countries table, but that could break any number of prior sales and existing customers; or adjust the query call, but we would have to find all queries to this table and make edits to the code - unless it is only the Registration page you are concerned about. To edit the query, open for editing the file /includes/content/reg.inc.php, at about line 203: Change this part of the statement: "SELECT id, printable_name FROM ".$glob['dbprefix']."CubeCart_iso_countries" to this: "SELECT id, printable_name FROM ".$glob['dbprefix']."CubeCart_iso_countries ORDER BY printable_name" Quote Link to comment Share on other sites More sharing options...
bigpedro Posted December 28, 2011 Author Share Posted December 28, 2011 Thank you ver ymuch indeed! That did the trick. Much appreciated!! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.