General discussion


Qx: Update/Delete MSAccess thru ODBC

By ymp ·
Please help me.
I am now using PHP to connect MS Access database thru ODBC. Data retrivial is ok but error is found in UPDATE and DELETE. Is anyone of you have problem as same as mine? How to deal with that?
The code is:
$fmsname = ($_POST["fmsname"]);
$fmfname = ($_POST["fmfname"]);
$fmemail = ($_POST["fmemail"]);
$connect = odbc_connect("douser", "", "");
$query = "UPDATE check SET fname='$fmfname',email='$fmemail' WHERE sname='$fmsname'";
Echo $query;
$result = odbc_exec($connect, $query);

The error message is:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Must use update query., SQL state S1000 in SQLExecDirect in E:\php\save.php on line 13

the link is:
Please help me.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums