Maybe you can use this function. I don't use MySQL, I use Oracle, and I
build this function for Oracle, but I think the basic problem (and solution
is the same). I think basically you need to escape ' by adding another '.
Thus "Ken's" should become "Ken''s".
function format_mysql_string($string)
{
$string = StripSlashes($string);
$string = ereg_replace("'", "''", $string);
return $string;
}
Reuben D. Budiardja
At 09:19 PM 3/12/01 -0600, Kenneth R Zink II wrote:
>My MySQL insert statements is returning errors when a field has an
>apostrophe in it. (I.E. Ken's) is there a way to get around that without
>using the \ in front of the apostrophes??
>
>I've never had this problem before, in the past (on different servers) when
>a variable is inserted, it just accepted it.
>
>Help!! I need to know A.S.A.P.
>
>Kenneth R Zink II [EMAIL PROTECTED] ICQ# 5095094
>'87 GMC S-15 Ext. Cab (Hurricane) ...BBC 524 being built !!!
>http://www.s-series.org/htm/windstorm/project-windstorm.htm
>'85 Chevy S-10 Blazer (FireStorm) ...Soon to be 3.4L SFI !!!
>http://www.s-series.org/htm/firestorm/firestorm.htm
>'84 Oldsmobile Delta 88 Delta 88 Royal Brougham.
>Racing by the grace of God!!!
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
