Re: insert a special character

Hi,

>        I have a string with ' this symbol in the middle of  the text
>      example:-
>              " that book belong to rahul's sister"
>
>     this string is to be stored in the variable "$strexp"
>     when I am inserting this variable in database table
>     following error apperes
>
>
>    " parse error at or near "s" "
>
>     How can I read the string and store in a variable and insert the same
>into the database table ?

Use the addslashes function.

Basically:
$newstring = addslashes($oldstring);
or
$newstring = addslashes("this is some sampl''e text''");

  See http://www.php.net/addslashes for more details.

Then, when you get it out of the database you need to stripslash the
string. (Does the above in reverse).

HTH,

-----------------
      Chris Smith
http://www.squiz.net/