User registration problem with State Abbreviation!!!

[pthurmond]

User registration problem with State Abbreviation!!!

How do you get OSCommerce to either allow the abbreviation or show the dropdown list by default.

Whenever I setup an account, if I use the abbreviation and submit it, it will throw out an error and then give you a drop-down list as an option. This is kinda weird.

I found a contrib for this, but the file to replace doesn't exist in OSCommerce (it may have been designed for an older version).
Contrib link: http://www.oscommerce.com/community/contributions,990

Please tell me of any suggestions!!!

[pthurmond]

Actually I found a code level workaround. This allows you to enter either the abbreviation or the full state name and it is not case sensitive...

 //This is the old query, the new one is posted below, this adjustment allows state abbreviations...
 //$zone_query = tep_db_query("select distinct zone_id from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' and (zone_name like '" . tep_db_input($state) . "%' or zone_code like '%" . tep_db_input($state) . "%')");

//This is the new code that is more leaniant
       $zone_query = tep_db_query("select distinct zone_id from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' and (zone_name = '" . tep_db_input($state) . "' OR zone_code = '" . tep_db_input($state) . "')");

The last line of code is what I used to fix it in create_account.php, which is located in the root of the catalog. The code itself is on or about line 135. I use OSCommerce v1.8 MS2-MAX. I got the basics of the code from that contribution I talked about in my first post, but had to adjust it some because the code was 2 years old and not correct with the current version. However the code I posted in this post is correct and works fine.

[pthurmond]

Ok, I have now packaged this into a contribution.

This contribution can be found at:
http://www.oscommerce.com/community/contributions,2316

It explains everything in detail.