[PHP-DB] another dumb newbie question - backslash before single quote

2001-01-15 Thread Timothy Wright
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

Re: [PHP-DB] another dumb newbie question - backslash before single quote

2001-01-15 Thread Kevin McCarthy
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