UPDATE MS ACCESS database using PHP

[crusty76]

Hi,

I've managed to read a record and insert a record but doing a record UPDATE is beyond me.

 

I've tried.

$query1 = "UPDATE data SET Header = $Header WHERE ID1= $id";

 

$cr1=odbc_exec($connect,$query1);

but get an error message.

 

PLEASE help an aged old Crusty. Where have I gone wrong please.

Crusty

[trq]

Your query doess not look valid.

 

$query1 = "UPDATE data SET Header = '$Header' WHERE ID1= '$id'";

[crusty76]

Thanks for the suggestion. Tried that but it doesn't work.

Message is:-

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect

 

It's all a bit frustrating. I've been at it now for a week :-)

 

crusty