I'm migrating some small php pages from Postgress 8.4.11/PHP 5.3.3 to Postgres 9.2.5/PHP 5.4.16, and I've fixed most of the issues relating to changing from DB to MDB2, but I can't get any database updates to work, I get a syntax error.
Here's a sample of the code:
$howmany=$mdb2->query('insert into sup_sup_response (
response_problem_no,
response_response_date,
response_date,
response_resolved_by,
response_description,
response_follow_up_dte,
response_time_spent) values (?,?,?,?,?,?,?)', $response);
Select all Open in new window
I get this syntax error:
The error was: MDB2 Error: syntax error
More Details: _doQuery: [Error message: Could not execute statement] [Last executed query: insert into sup_sup_response ( response_problem_no, response_response_date, response_date, response_resolved_by, response_description, response_follow_up_dte, response_time_spent) values (?,?,?,?,?,?,?)] [Native message: ERROR: syntax error at or near "," LINE 8: response_time_spent) values (?,?,?,?,?,?,?) ^]
I tried:
$howmany=$mdb2->query('insert into sup_sup_response (
response_problem_no,
response_response_date,
response_date,
response_resolved_by,
response_description,
response_follow_up_dte,
response_time_spent) values ($response[0], $response[1]..etc)';
Select all Open in new window
but that didn't work either.
It's been years since I've done anything in php, so I'm stumped.
What am I missing?
Thanks.