Back To Programming / Scripting / Coding Forum

length for decimals in mysql

  • DavyDuke17
  • Graduate
  • Graduate
  • No Avatar
  • Joined: Dec 20, 2003
  • Posts: 166
  • Status: Offline

Post July 15th, 2004, 6:48 pm

I want to have a decimal number in a mysql database which displays a number like .455 . It has 3 places after the decimal places, and no numbers before it. So I believe the proper length for it would be 3,3 right? Well, I put that in phpmyadmin and it is automatically changing it to 4,3 so that there is a 0 before. So the number would end up being 0.455 instead. Is there a way I can fix this, possibly use php to take the 0's out as I display them?
Baseball-Now
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post July 15th, 2004, 6:48 pm

  • DavyDuke17
  • Graduate
  • Graduate
  • No Avatar
  • Joined: Dec 20, 2003
  • Posts: 166
  • Status: Offline

Post July 21st, 2004, 11:57 am

Any help?..., do you understand my question?
Baseball-Now
  • quantumcloud
  • Proficient
  • Proficient
  • User avatar
  • Joined: May 11, 2004
  • Posts: 456
  • Loc: Dhaka, Bangladesh
  • Status: Offline

Post July 21st, 2004, 12:43 pm

What version of Mysql you are using?
Web development company : quantumcloud

Web design company : web.com.bd
  • RichB
  • Guru
  • Guru
  • User avatar
  • Joined: May 17, 2003
  • Posts: 1121
  • Loc: Boston
  • Status: Offline

Post July 21st, 2004, 12:50 pm

Once you have the value in a php variable you could maybe use something like strstr to get rid of the leading 0:

PHP Code: [ Select ]
<?php
 
$var = 0.455;
 
$var = strstr($var, '.');
 
echo "var = $var";
 
?>
  1. <?php
  2.  
  3. $var = 0.455;
  4.  
  5. $var = strstr($var, '.');
  6.  
  7. echo "var = $var";
  8.  
  9. ?>
Free Programming Resources

Page 1 of 1

Post Information

  • Total Posts in this topic: 4 posts
  • Users browsing this forum: No registered users and 131 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.