[thelist] SQL - Field Types...

[Dave Stevens]

--
[ Picked text/plain from multipart/alternative ]
Hi all,

I have a table in a MySql database, which contains a field, amongst others, called "Price" which is not just a clever name - it contains the price of a product.

I need to be able to add up prices on an orderform later on, so what field type would be best for this field?

I saw DECIMAL, is this a good option?

Grateful as ever,
Dave Stevens
--