Posted by Chris on 10/20/50 11:24

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);
>
>
>

[Back to original message]