Need help storing HEX,DEC. value from color picker to MySQL database

[eawade]

Hey Guys,

I'm having a very difficult time. I'm not sure exactly what to do. I have a form that contains fields for HEX, DEC value. I'm using a color picker (RGB ColorPicker 1.1) along with php5 and MySQL. All I want to do is be able to save the HEX, DEC values from the textfields to a MySQL database. I've been trying but with no success.

If anyone has any experience with this, I'd appreciate the input.

Thanks
E.A.

What seems to be the problem?
Give an idea of your table structure with data types.
Are you including the '#' in front of the HEX value?
Your HEX field should be 7 characters long: (data type: char, length: 7)

BTW:

I noticed you posted this on http://www.webmasterworld.com/php/3850855.htm as well. Covering bases?!

[eawade]

Hey Ardav,

Thanks for the quick reply. Yeah I also posted on Webmasterworld. I was so frustrated with this - racking my head. I just got up from a nap and will verify my table structure. I'm not so sure that I was using the right data type. I can tell you that I was not including the '#' symbol. I'll let you know. Either way, THANKS a mil for your feedback.

Thanks,
E.A.