Prepping data for MySQL from input

[RandaJ99]

Hi,

Should be a simple question.  I'm pretty new to PHP.  I need to know how to prep a field for input into a MySQL database with garbage in the field such as :;'@$  that sort of thing.  These symbols can be used for times e-mail address's etc.  The problem I have is that when I believe the colon is in a field it errors out the insert.  What can I do to "clean" the data or prep it for insert as a legitimate character.

Thanks,

Randal

[m_tt]

Just be sure to use addslashes() for error and security reasons

http://www.php.net/addslashes

[RandaJ99]

Thanks a lot that worked perfectly!