[PHP] Adding a variable to oracle that contains quotation marks??

[Rea_David]

Hi All,

        I'm trying to add a variable to an oracle database but it fails due
to the fact that it contains quotation marks.  These have to be present for
the end user. My Script is as follows:
===========================================================
        if ($conn == true)
        {

        $query = "UPDATE ACTIVITY
                        SET COMMENTS = '$updatecomments' WHERE ACTIVITY_ID =
'$actcode'";
        $cursor = Ora_Open ($conn);
        $result = Ora_Parse ($cursor, $query); 
        $result = Ora_Exec ($cursor); 

        ora_close($cursor);
        Ora_Logoff($conn);
        } 
===========================================================

Can anyone tell me what to do!

Thank you 
Dave

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php