Welcome to WebmasterWorld Guest from 54.162.107.231

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

how do i query for PHP?

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

Junior Member

10+ Year Member

joined:Apr 20, 2006
posts:109
votes: 0


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?

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

Junior Member

10+ Year Member

joined:Dec 18, 2004
posts:53
votes: 0


[w3schools.com...]

try select distinct

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

Junior Member

10+ Year Member

joined:Apr 20, 2006
posts:109
votes: 0


thanks.. i never thought about distinct.. hahahahaa...
6:25 pm on May 28, 2007 (gmt 0)

Junior Member

10+ Year Member

joined:Apr 20, 2006
posts:109
votes: 0


by the way, how do i format a currency?

for example the number is 190000

how do i convert to 190,000.00

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

Administrator

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

joined:July 24, 2001
posts:15755
votes: 0


[php.net...]
or
[php.net...]
6:45 pm on May 28, 2007 (gmt 0)

Junior Member

10+ Year Member

joined:Dec 18, 2004
posts:53
votes: 0


[ca.php.net...]

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

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

Junior Member

10+ Year Member

joined:Apr 20, 2006
posts:109
votes: 0


thanks bozz.. copy that...
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members