Hi, I'm using the following statements to insert a record into a table:
Advertising
$SQL_Exec_String = "Insert Into Messages (ReplyID,Subject,Sender,Email,Message,Reviewed) 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? Thanks! ___________________ John Long www.wiseheart.20m.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
