Posted by Jerry Stuckle on 03/14/07 03:33

Rik wrote:
> G-Rod <futbolguy@gmail.com> wrote:
>
>> I seem to have figured out what my error was. It doesn't like an
>> apostrophe in the middle of one of my variables.
>>
>> How do you insert something like "George's" into a field? Is there a
>> remove apostrophe's function?
>
> You want to escape (among others) the ', by using
> mysql_real_escape_string() on _all_ data added to the query.
> --Rik Wasmus
> Posted on Usenet, not any forum you might see this in.
> Ask Smart Questions: http://tinyurl.com/anel

All *string* data, that is.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]