homepage Welcome to WebmasterWorld Guest from 54.226.230.76
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
how do i query for PHP?
camilord




msg:3351865
 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):
===============================
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




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

[w3schools.com...]

try select distinct

camilord




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

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

camilord




msg:3351904
 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

jatar_k




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

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

CDNQuilter




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

[ca.php.net...]

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

camilord




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

thanks bozz.. copy that...

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved