how do i query for PHP?

[camilord]

how do i query this kind of values...

this is what i want to happen, i have a table of all currencies in the world. we all know that the ISO code of America, British, Caicos and other country are the same... USD.

how do i query to get only 1 USD in the table...

for normal query:

table description (currencies):
===============================
isoCode varchar(10)
Country varchar(250)

mysql> select isoCode from currencies;

---
and the result is not good cause a lot of USD is there in the results... how can i have a single USD?

[CDNQuilter]

[w3schools.com...]

try select distinct

[camilord]

thanks.. i never thought about distinct.. hahahahaa...

[camilord]

by the way, how do i format a currency?

for example the number is 190000

how do i convert to 190,000.00

[jatar_k]

[php.net...]
or
[php.net...]

[CDNQuilter]

[ca.php.net...]

[edited by: CDNQuilter at 6:46 pm (utc) on May 28, 2007]

[camilord]

thanks bozz.. copy that...