Getting error with this code

[Anon]

here's the code:

$conn = odbc_connect( 'CoffeySports' , 'root' , '' );

$addheadline_query = "INSERT INTO CoffeySports (headlines,fullstory) VALUES ('$headlines','$fullstory')";

odbc_exec( $conn, $addheadline_query );

I know my variables are passing from the previous page and I know everything is spelled right.

Here's the error I'm getting:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''Big \'ol loss for them Braves')'., SQL state 37000 in SQLExecDirect in F:\web_docs\seth_cox\scdevelopments\php\addprocess.php on line 14

Line 14 is my odbc_connect statement

Any ideas? Thanks so much,

Seth

[Anon]

Hi Seth,
It seems the quotes and escape characters are causing the error.
Escape characters for Access database are different i think.
Before executing the query escape the quotes with Access escape character.

  i.e $headlines=str_replace("\'","''",$headlines); 
  do the same for full story.

Hope this works

Cheers
Ajay