Thread: Default state
View Single Post
  #22  
Old 09-23-2009, 02:26 AM
 
Steve-C Steve-C is offline
 

Senior Member
  
Join Date: Jan 2006
Location: England
Posts: 172
 

Default Re: Default state

Quote:
Originally Posted by Steve-C
Does anyone have a fix to make the "states" sort properly in Firefox without affecting Internet Explorer?

I've no idea how to fix this by coding but if anyone is interested I made mine OK by re-sorting the database file.

In the database table there are the state names "state" and each one has a number associated with it "stateid". IE sorts by "state", FF sorts by "stateid".

I exported the table and in Excel I sorted the whole table by "state", then I moved my ---Please Select--- field to the top of the list. Next I sorted the "stateid" column ONLY so that it went straight down starting at 1 (the "please select" field).

After re-importing the table in phpMyAdmin it works fine in both browsers.

If you ever have to add or change the states you'll need to do it all again.
__________________
X-Cart Gold v 4.3.2
X-AOM, Marketing Manager, On Sale
Reply With Quote