the311guy Posted October 8, 2005 Share Posted October 8, 2005 I need to make my US states only 2 digits in the database when someone orders a product. I noticed the US States are 2 digits during the order confirmation process, but in the orders database table they are stored as the full names. My order fulfillment company can only handle 2 digit us state abbreviations. someone please help! Link to comment Share on other sites More sharing options...
niknakgroup Posted October 8, 2005 Share Posted October 8, 2005 You need to amend the names in your "zones" table, at the minute they are deined with the full names, edit the table to show only the two digit code and this is what will be printed out. Please note - if I have suggested a contrib above, it doesnt mean it will work! Most of the contribs are not ones I've used, but may be useful for your particular problem.... Have you tried a refined search? Chances are your problem has already been dealt with elsewhere on the forums..... if (stumped == true) { return(square_one($start_over) } else { $random_query = tep_fetch_answer($forum_query) } Link to comment Share on other sites More sharing options...
the311guy Posted October 8, 2005 Author Share Posted October 8, 2005 I would still like the names of the states to exist, a drop down table with just state abreviations isnt web standard and slightly confusing. Any other way to use the 2 state abbreviation? Perhaps somehow using the zone "code" instead of the zone "name"? Link to comment Share on other sites More sharing options...
the311guy Posted October 10, 2005 Author Share Posted October 10, 2005 anyone think they can help? Link to comment Share on other sites More sharing options...
♥Vger Posted October 10, 2005 Share Posted October 10, 2005 Look in Contributions and in Tips & Tricks in the Knowledge Base - because in one of them there is a fix for this problem. Vger Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.