store the value in a named variable, then call the variable with the
stripslashes() function before inserting it into the DB.
a la:
$event = "St. Patrick's Day";
$event = stripslashes($event);
insert table values('$event'); ....
At 02:13 PM 1/15/2001 -0500, Timothy Wright wrote:
>Hello -
>
>I have set up a calendar database with MySQL and PHP that uses simple text
>and tinytext fields for events and event descriptions. The problem is,
>whenever I enter an event that uses an apostrophe ( St. Patrick's Day) or a
>description (4 o'clock) it stores and returns ( St. Patrick\'s Day) from the
>database. Any suggestions?
>
>Thanks in advance,
>
>Tim Wright
>
>:::::::::::::::::::::::::::::::::::::::::::
>::: :::
>::: Timothy Wright :::
>::: mailto:[EMAIL PROTECTED] :::
>::: Digital Network Enterprises :::
>::: http://www.01network.com :::
>::: :::
>::: secure e-mail by request :::
>::: (PGP signature and/or encryption) :::
>:::::::::::::::::::::::::::::::::::::::::::
>
>
>--
>PHP Database 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]
Kevin McCarthy Body & Soul
http://www.bodynsoul.com
--
PHP Database 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]