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.