[RESOLVED] Value of a string

[Dawg]

I need to test the value of a sting input. The amount is entered as a decimal "1,234.56" and I need to get the value.

I am saving the output to a DB field which is a double(10,2). But MYSQL does not like the comma in the string.

Anyone done this

Thanks
Dave

[Installer]

Here's one way:

$str = str_replace(array(',', '.'), '', $str);

[Installer]

Wait. You want to keep the decimal, don't you? 🙂

$str = str_replace(',', '', $str);

You could also do it in the query with REPLACE and CAST.

[Dawg]

I should have figured that one out. Thanks

But once I retrieve the data I need to display it as currency again with all its associated commas. I'll have to look up some formating code. I get my data with a SELECT * FROM..... because I need all the data and it is easier to just get the whole record.

Thanks

[Dawg]

I am going to use the number_format() for data display. It looks great.

Thanks to ALL