General discussion

Locked

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:
<?php
$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);
odbc_close($connect);
?>

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:
http://www.ympoon.com/php/userdb.php
Please help me.

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums