PHP & MySQL insert question

[rickpick77665]

I have a form that is inserting a selected color (e.g., #663300).  I want to insert the value into the database without the "#".  How do I delete that and just insert the actual numbers into the database?

[Guest]

I just did a quick search on google for php strip characters and found some intersting results.

[Guest]

Let's say your color code is in $color_data variable:

INSERT INTO color_table(color_code) VALUES(SUBSTRING('{$color_data}', 2))