backslash escape the quote:
$field="Joe\'s car";
or if you're using PHP you can turn this on automatically
HTH
Steve
Nestor Florez wrote:
Hello world,
I am passing a a string "Joe's car" as part of the SQL query to be inserted
to a String field.
$field="Joe's car"; $query="insert into mytable values('$field')";
Do you generally change the quote to a double quote before inserting or what is the recomended way, because otherwise the quote will terminate the query statement.
Thanks,
:-)
Néstor Alberto Flórez Torres
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
