physaux Posted November 3, 2009 Share Posted November 3, 2009 what Kind of field should I put into my table, so that I can enter such numbers? I put "decimal" but It set the range(?) to [0,10], and kept rounding my number to an int (0). How can I fix this? Quote Link to comment https://forums.phpfreaks.com/topic/180199-solved-creating-mysql-table-want-to-insert-gps-numbers-ex-1271837192-but-sets2int/ Share on other sites More sharing options...
MadTechie Posted November 3, 2009 Share Posted November 3, 2009 int (integer) is a whole number (no decimal points) ie 10 or 20 you want a float (floating point) ie 12.345 or 45.789 EDIT: MySQL numeric type overview Quote Link to comment https://forums.phpfreaks.com/topic/180199-solved-creating-mysql-table-want-to-insert-gps-numbers-ex-1271837192-but-sets2int/#findComment-950600 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.