| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|how do i query for PHP?|
| 5:37 pm on May 28, 2007 (gmt 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):
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)|
try select distinct
| 6:13 pm on May 28, 2007 (gmt 0)|
thanks.. i never thought about distinct.. hahahahaa...
| 6:25 pm on May 28, 2007 (gmt 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)|
| 6:45 pm on May 28, 2007 (gmt 0)|
[edited by: CDNQuilter at 6:46 pm (utc) on May 28, 2007]
| 7:52 pm on May 28, 2007 (gmt 0)|
thanks bozz.. copy that...
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved