Gossamer Forum
Quote Reply
Sorting by currency

I am looking for a way to sort by numbers without having to pad the database field.

So, if I have a field titled "price" and I specify to sort by that field I want to be sure that $9.99 comes before $19.99

I understand that I can enter these numbers into the database as 009.99 & 019.99 and they will sort properly, but since I am importing large numbers of links this is not feesible.

Any help would be appriciated

Quote Reply
Re: [macbethgr] Sorting by currency In reply to
Try changing the field to FLOAT - I think you may need to do this in mysqlman as I don't think it is a choice in the admin.