X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)
-   -   Default state (https://forum.x-cart.com/showthread.php?t=45161)

Steve-C 09-21-2009 10:09 AM

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

Steve-C 09-23-2009 02:26 AM

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.


All times are GMT -8. The time now is 08:22 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.