Apostrophe make problems

[jaddy]

Hi,
Whenever I add to any field in my form the aposrophe charachter ( ' ), I get an error.

How can I maintain this bug??

Thanks

[sarahk]

I guess you're hitting errors when you try to save to a database. When creating your insert string try this

$sql = "insert into mytable (id, subject, notes) values "
  . "( NULL, '" . addslashes($subject). "', '" . addslashes( $notes) . "')";

then when you retrieve you need to use stripslashes()

[ShawnD]

the thing has to be written as slash '

editted because it won't let me have the slash in my post. you need the one that goes from top left to bottom right 😉

[The_Chancer]

Either that or turn magic_quotes_gpc on in your PHP.ini file... that means you won't need to add them to the insert query.

HOWEVER

If you are using the data from one table and using it to get data from a different table, then you will need to use the code as specified by SarahK in your select query.