Currency Conversion & Sorting

[ldtiw]

I found this script:

http://www.white-hat-web-design.co.uk/articles/php-currency-conversion.php

from a google search, and i had a quick question. The code works fine and all is cool. But what im wanting to know is this:-

I have listings on my site in 4 different currencies. If i was wanting to sort them using GBP, how would i do this in my select statement? If i have 6 listings using GPB, 3 using AUD and 3 using USD.... how would i change them all to GBP for correct sorting for a results page - ordered by price?

Thanks in advance,

Danny

[wilku]

If you pull your results from some database (with pagination for example) it would be hard to do, because you tell the datatabase to sort the results and give only a limited amount of records.
But if you pull all results at once, just store all the records in an array. Then for each record create new field in array, where you store price converted to GBP. Sort the array with this field (see [man]usort[/man]).

[Sxooter]

What do your tables and data look like?