Welcome to WebmasterWorld Guest from 54.144.126.195

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

how do i query for PHP?

     

camilord

5:37 pm on May 28, 2007 (gmt 0)

5+ Year Member



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

6:04 pm on May 28, 2007 (gmt 0)

10+ Year Member



[w3schools.com...]

try select distinct

camilord

6:13 pm on May 28, 2007 (gmt 0)

5+ Year Member



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

camilord

6:25 pm on May 28, 2007 (gmt 0)

5+ Year Member



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

6:44 pm on May 28, 2007 (gmt 0)

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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

CDNQuilter

6:45 pm on May 28, 2007 (gmt 0)

10+ Year Member



[ca.php.net...]

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

camilord

7:52 pm on May 28, 2007 (gmt 0)

5+ Year Member



thanks bozz.. copy that...
 

Featured Threads

Hot Threads This Week

Hot Threads This Month