simple data type question

[coderwasp]

I am filling a database field with valuse such as 67.50; they are either integers or decimal numbers.

What data type should I use in the db:

float
double
or decimal

What is the advantage of using either?

 

[rac2]

See

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

...
The FLOAT and DOUBLE data types are used to represent approximate numeric data values.
...
The DECIMAL and NUMERIC data types are used to store exact numeric data values.