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? 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 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
Archived
This topic is now archived and is closed to further replies.