On Fri, 2001-12-14 at 04:14, Peter Lovatt wrote: > Hi > > I am retrieving data from a mysql table and displaying the contents in a > text box for editing. > > Some of the data contains double quotes eg '15" screen'. Using php4 the data > is backslashed and stores without any problem, but when it is displayed in > the text box it stops at the ", because that closes the value area of the > input, and then when it is reinserted after updating it gets truncated at > the ". > > Is there a way round this?
You'd have to quote the backslash too. I had the same problem with the CONCAT_WS function, and it turned out to be an escaping inferno. Store the 15" screen using '15\\\" screen' in PHP, and it should work. Cheers, Markus -- Markus Lervik Linux administrator with a kungfoo grip Vasa City Library - Regional Library --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php