Forum Moderators: coopster

Message Too Old, No Replies

which SQL datatype for values like "1.3" "3.5" ?

         

carsten888

6:28 pm on Apr 12, 2008 (gmt 0)

10+ Year Member



I need to store values in a db table like:
1.3
3.7
4.6
etc.
when I try datatype tinyint the values loose their dot and the number behind it. With tinytext it works, but I realy need it to be numbers so 4,5
becomes
4.5
(notice the comma becomes dot)
its data which will have to be a bar chart in the front end, so no letters. when I try getting the post-values with intval($_POST['thing']); it returns nothing.

Demaestro

7:31 pm on Apr 12, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



it is usually called a "double". Sometimes called "float"

carsten888

6:08 am on Apr 13, 2008 (gmt 0)

10+ Year Member



thank you, that was exactly what I needed.