[thelist] php escaped characters problem

Warden, Matt mwarden at odyssey-design.com
Mon Jun 19 10:44:36 2000


> I have a written a simple php/mysql news input interface for our admin
staff
> to add articles to our website. When they have an article name containing
a
> single quote, the string is cut off at that point on generation of the sql
> string.

I'm not in PHP mode right now, so you'll have to find the actual function
name yourself :-)

Replace a single ' with '' (two '). Now, make sure that you are using double
quotes to delimit strings in this section rather than single quotes, or
things can get hairy/harry.

--
mattwarden
mattwarden.com