when i insert a string variable such as $number that contains 2.6 into mysql, it rounds it to 2. how can i leave the decimals intact?
Check the column type on MySQL and see if it is an integer.
its a smallint(5) type. however, if i use varchar it will work.
Ints (and smallints, etc) don't have decimal points. Use a decimal type to get what you want.
THANKS, IT WORKS.