Rounding Down

SirJinX · 22-05-2005, 23:10

So,
I want to store a number into a MySQL DB.
Except it's numbers like 90.5 or 110.123 and numbers like that.
If I put it on float, it saves it the way it is. If I put it on integer, it rounds it up.
Anyone know how to round it down?

Thanks

Cridiron · 22-05-2005, 23:22

Uhmmm it seems like you answered your own question...put it as an integer...

SirJinX · 23-05-2005, 03:29

Dam, I ment it round it up :S
Going to edit the post...

Cridiron · 23-05-2005, 17:53

Does it round up no matter what? like I know it will round up if it's 5 or over, but will it still round up if it's a number like 12.1? Cause mathematically, it should be rounded down because the decimal is lower than 5.

SirJinX · 23-05-2005, 18:58

It was a long time ago since I checked for it tough,
I don't quite remember

Except, I would still like the numbers about x.5 to be rounded down...

Cridiron · 23-05-2005, 20:52

Hmmm I don't know...I'm not very good with storing numbers and values into databases. Sorry... You can try googling it though

vegancoder · 25-05-2005, 15:45

use this function to round down to the next integer:

PHP Code:

  floor();

Then insert the new value into the database, hope that helps

SirJinX · 25-05-2005, 20:08

ok thanks, I will try that later

vegancoder · 27-05-2005, 02:30

it should work, i hope it does, its nice to help people

22-05-2005, 23:10	#1 (permalink)
SirJinX WMT Addict Join Date: Apr 2005 Posts: 128 iTrader: 0 / 0%	Rounding Down So, I want to store a number into a MySQL DB. Except it's numbers like 90.5 or 110.123 and numbers like that. If I put it on float, it saves it the way it is. If I put it on integer, it rounds it up. Anyone know how to round it down? Thanks Last edited by SirJinX; 23-05-2005 at 03:29.

22-05-2005, 23:22	#2 (permalink)
Cridiron WMT Addict Join Date: Apr 2005 Posts: 278 iTrader: 0 / 0%	Uhmmm it seems like you answered your own question...put it as an integer... __________________ Cridiron.com

23-05-2005, 17:53	#4 (permalink)
Cridiron WMT Addict Join Date: Apr 2005 Posts: 278 iTrader: 0 / 0%	Does it round up no matter what? like I know it will round up if it's 5 or over, but will it still round up if it's a number like 12.1? Cause mathematically, it should be rounded down because the decimal is lower than 5. __________________ Cridiron.com

23-05-2005, 20:52	#6 (permalink)
Cridiron WMT Addict Join Date: Apr 2005 Posts: 278 iTrader: 0 / 0%	Hmmm I don't know...I'm not very good with storing numbers and values into databases. Sorry... You can try googling it though __________________ Cridiron.com

25-05-2005, 15:45	#7 (permalink)
vegancoder Active Member Join Date: May 2005 Location: Doncaster, UK Posts: 58 iTrader: 0 / 0%	use this function to round down to the next integer: PHP Code: `floor();` Then insert the new value into the database, hope that helps

23-05-2005, 03:29	#3 (permalink)
SirJinX WMT Addict Join Date: Apr 2005 Posts: 128 iTrader: 0 / 0%	Dam, I ment it round it up :S Going to edit the post...

23-05-2005, 18:58	#5 (permalink)
SirJinX WMT Addict Join Date: Apr 2005 Posts: 128 iTrader: 0 / 0%	It was a long time ago since I checked for it tough, I don't quite remember Except, I would still like the numbers about x.5 to be rounded down...

25-05-2005, 20:08	#8 (permalink)
SirJinX WMT Addict Join Date: Apr 2005 Posts: 128 iTrader: 0 / 0%	ok thanks, I will try that later

27-05-2005, 02:30	#9 (permalink)
vegancoder Active Member Join Date: May 2005 Location: Doncaster, UK Posts: 58 iTrader: 0 / 0%	it should work, i hope it does, its nice to help people

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode