Re: addslashes to mysql read


[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]

Posted by Barbara Brazil on June 20, 2020 at 08:34:05:

In Reply to: addslashes to mysql read posted by JEFFREY HARDING on June 19, 2020 at 15:42:24:

Hi, Jeff. Not being a mysql user I had to google this. Now I understand the issue. For others, here's the deal:
If you need to use single quotes and double quotes in a string that contains both a contraction and a quote, you will need to use the backslash ‘' to cancel out the following character. For example: a string containing this ' will recognize the backslash as an instruction to cancel out the single quote’s syntactical meaning and instead insert it into the string as an apostrophe.

SELECT 'They\'ve responded, "We found this tutorial helpful"'

To answer your question, no there is not a Comet function that will do this for you.


Follow Ups:



Post a Followup

Name:
E-Mail:

Subject:

What is the name of the main Signature System's Product?  

Comments:

Optional Link URL:
Link Title:
Optional Image URL:

You may attach up to 5 files to your followup (see below):





Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.


[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]