[RESOLVED] How do you convert a str to a dec for storage?

[Phrank]

My input field on the form is cost. That gets a string - right? The db has cost as a decimal 10,2. If I don't put a value in the cost field on the form when I try to add the data to the database I get an error.

What function converts a string to a decimal?

Sorry if this is too easy.

TAI

[NogDog]

There are a number of ways to approach it, but since you want a numeric value with two decimal places, I'd probably just [man]round/man it:

$cost = round($_POST['cost'], 2);

And of course at that point you should verify the value is within any range constraints before proceeding to use it in your query.

[Phrank]

Worked great! thank you very much.