MySQL Forums
Forum List  »  General

Re: Problems with a INSERT of a textarea
Posted by: Rafael Muller
Date: November 17, 2004 10:19AM

delta:

Thanks for the info. I did as you mentioned and what I have noticed is that if the text contains doublequotes the insert fails. How do I construct the insert such that it is possible to have doublequotes or is that something I need to string replace?

Raf


delta wrote:
> Have you tried to escape vnt_case_notes which in
> effect would be done by escaping
> $_POST['casenote'] using mysql_real_escape_string
> ?
> http://us2.php.net/manual/en/function.mysql-real-e
> scape-string.php
>
> Have you tried inserting a much simpler case note
> such as "hello" to see if the problem is in your
> data, code, or MySQL? You could echo the query,
> copy and paste into phpMyAdmin's direct SQL input
> and see what MySQL says.

Options: ReplyQuote


Subject
Written By
Posted
Re: Problems with a INSERT of a textarea
November 17, 2004 10:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.