encoding text for use in mysql table

[diarmuid]

i've run into a problem when trying to insert data to a mysql table.

for example: when i try to insert a variable who's value is "because you're cool', it'll return an error saying my sql syntax is wrong because of the [b]'[/b] in "you're"

what i've been looking for is a script, or snippet, that will place \'s infront of all characters that will cause problems with mysql.

also, i need one that'll do the opposite, when i read data from a mysql table, that has been processed by the above script, i need a second script to remove any "\" that was inserted from the first script..

hopefully you all followed this :)

thanks,
Chad.

[strikelight]

If you are using mysqltcl, use the 'mysqlescape' command...
You should consult the docs for the mysqltcl extension before asking such questions though..