Modifing Data before insertion into DB

[CHAINLINK_2006]

Hello everyone.

I have a problem and I hope someone has a solution. I have a column in a database that has data like "1000,,,,,,," and "1000,1040,,,,,,," on and on. I was wondering if anyone knows how to remove the commas before it is inserted into the DB. I have setup 7 dropdown boxes that must have the same name. If anyone has any ideas please let me know.

-CHAINLINK_2006

[amir]

let me c ur code
Regards,
Aamir.

[Velox Letum]

str_replace() (http://www.php.net/function.str-replace) ?

[Tangerine Dream]

Hi, you can also use MySQL REPLACE (http://dev.mysql.com/doc/mysql/en/string-functions.html) function

[CHAINLINK_2006]

Hey,

Thanks anyway. I figured it out.