I'm using the following statements to insert a record into a table:

$SQL_Exec_String = "Insert Into Messages
   Values ($ReplyID,'$Subject','$Sender','$Email','$Message',$Reviewed)";
 $cur = odbc_exec( $cnx, $SQL_Exec_String );

This works great except when I have a string like "don\'t get in my way"
which has an apostrophe in it and causes the statement to get confused. It
seems to me that SQL should have an escape sequence of some kind. Can
someone get me pointed in the right direction?

John Long

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to