Re: problem with ' or "
| From: | George B | Date: | Wed, 24 Aug 2005 05:54:47 +0000 |
| Subject: | Re: problem with ' or " | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-221226@lists.php.net to get a copy of this message | ||
Jasper Bryant-Greene wrote:
George B wrote:Jasper Bryant-Greene wrote:Example: $value = mysql_real_escape_string($_POST['value']); $results = mysql_query("SELECT * FROM sometable WHERE field='$value'"); Jasper THANKS!! it works!!George B wrote:Where do I put the code in?I made a script that posts data into a database but it has a problem whenever I enter a ' or a ". How do I bypass this problem?If it is MySQL, use mysql_real_escape_string() [1]. If any other database, have a look in the PHP manual [2] for the relevant function, or as a last resort use addslashes(). Jasper [1] http://www.php.net/mysql_real_escape_string [2] http://www.php.net/docs.php