Extra field value order

[wabugi]

I'm a bit confused about the order of extra field values.

When I create a new extra field I enter the values from left to right and then continue in the next row. When I later take a look at the final drop down list in the search or checkout-function, the values are sometimes ordered alphabetically. Sometimes they are completely mixed.

Some minutes ago I created a new drop down extra field with some values and saved it. After saving I took another look at it by using the edit function. The values were still there but they had another order than before.

How can I influence the order? The best thing would be if the values were displayed in the same order as I enter them.

[seymourjames]

As far as I am aware (I will stand corrected), the values in extra-fields like categories will be ordered alphabetically.

[wabugi]

That seems to be right for the extra field editor. But the search function often displays them in a random order

Alphabetically would be ok. But would be better if the order would be the same as I entered the values in the editor.

[Eric Barnes]

They are supposed to be ordered alphabetically. The ajax.php is where these are pulled from and it is missing the order by which is probably the reason for the random.

You can fix this with the developer edition by editing ajax.php line 230.
Find:
WHERE fieldID='".$row['fID']."'";
Replace with:
WHERE fieldID='".$row['fID']."' ORDER BY optValue";

[wabugi]

Now it's ordered alphabetically. Thanks

EDIT: I took another look at the ajax.php. When I set it like this:

WHERE fieldID='".$row['fID']."' ORDER BY optID";

The values are ordered by the value id. The result is that the values are ordered exactly like I have entered them in the extra field editor. And that's exactly what I needed for some fields

[DGiscombe]

This does not work for me, strangely.

Is there anything else i can look out for?

developer 4.1