X-Cart forums

[Steve-C]

Does anyone have a fix to make the "states" sort properly in Firefox without affecting Internet Explorer?

[Steve-C]

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.