Re: PHP MySQL insert
| From: | Chris | Date: | Thu, 18 Aug 2005 17:05:50 +0000 |
| Subject: | Re: PHP MySQL insert | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-220881@lists.php.net to get a copy of this message | ||
You need to escape the data, so....
$data1 = mysql_real_escape_string($data1,$rLink);
$data2 = mysql_real_escape_string($data2,$rLink);
Jon wrote:
Please help with an insert problem. Sometimes $data1 could have a comma and that messes up the insert. how do I get around that? $query = "insert into testtable6 (indx, col1, col2) values (NULL, '$data1', '$data2')"; mysql_db_query("testdb", $query);