|
|
Posted by Rik on 03/14/07 08:36
Jerry Stuckle <jstucklex@attglobal.net> wrote:
> 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.
>
> All *string* data, that is.
Well, yeah. Allthough MySQL prefectly understands quoted integers &
floats, there are other functions for that indeed (intval()/floatval()).
--
Rik Wasmus
Posted on Usenet, not any forum you might see this in.
Ask Smart Questions: http://tinyurl.com/anel
Navigation:
[Reply to this message]
|