how to insert a decimal from html form?

[michael0224]

My problem: taking input from html form to add a record to mysql table

<form name="priceit" id="additem" action="priceit.php" method="post">
   Price (###.## in CDN) * <input type="text" name="price" id="price">
</form>

the price column's attribute in Mysql database table is decimal (5,2)

If I just insert the price from the form to the db table, it wn't be added because it is a text.. and the db takes decimal only.
I believe there's some method to convert a text to a decimal format before insert to the db.

I searched on the web for a while but still haven't find anything like this... How to do it with php? Do other people usually use text for all fields, instead of number formats?

Thanks a lot.

[michael0224]

I found out my problem. It wasn't about the code... I am so stupid that I spent one whole day searchin for the cause...