Current location: Hot Scripts Forums » Programming Languages » PHP » Price display


Price display

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 10-24-07, 05:34 PM
blinn_shade's Avatar
blinn_shade blinn_shade is offline
Aspiring Coder
  
Join Date: Aug 2007
Posts: 540
Thanks: 0
Thanked 0 Times in 0 Posts
Price display
Hey,

What would be the SQL data type for a price column?

Also say I have 1,000,000 or 99.99 (USD) and they are entered into the database how do I get php to display the decimal and thousand points?

Thanks.
Last edited by blinn_shade; 10-24-07 at 05:50 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #2 (permalink)  
Old 10-24-07, 05:46 PM
Nico's Avatar
Nico Nico is offline
Community Leader
  
Join Date: Sep 2005
Location: Spain
Posts: 8,074
Thanks: 11
Thanked 88 Times in 83 Posts
Topic moved to database.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #3 (permalink)  
Old 10-24-07, 05:50 PM
blinn_shade's Avatar
blinn_shade blinn_shade is offline
Aspiring Coder
  
Join Date: Aug 2007
Posts: 540
Thanks: 0
Thanked 0 Times in 0 Posts
This is actually a php question. I just put about the SQL thing first because it technically comes first right.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #4 (permalink)  
Old 10-24-07, 06:04 PM
Nico's Avatar
Nico Nico is offline
Community Leader
  
Join Date: Sep 2005
Location: Spain
Posts: 8,074
Thanks: 11
Thanked 88 Times in 83 Posts
Moving back then if you want.


And have a look at www.php.net/number_format
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #5 (permalink)  
Old 10-24-07, 06:16 PM
blinn_shade's Avatar
blinn_shade blinn_shade is offline
Aspiring Coder
  
Join Date: Aug 2007
Posts: 540
Thanks: 0
Thanked 0 Times in 0 Posts
Thanks mate. I will look there.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #6 (permalink)  
Old 10-24-07, 06:23 PM
blinn_shade's Avatar
blinn_shade blinn_shade is offline
Aspiring Coder
  
Join Date: Aug 2007
Posts: 540
Thanks: 0
Thanked 0 Times in 0 Posts
Issue sorted. Thanks
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
Reply

Bookmarks

« Strip HTML | mysql searching »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT -5. The time now is 11:49 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.