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       :::
>:::          :::
>:::                                     :::
>:::   secure e-mail by request          :::
>:::   (PGP signature and/or encryption) :::
>PHP Database Mailing List (
>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

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to