Sujit Joshi
Thread Starter
- Joined
- Jun 24, 2005
- Messages
- 18
hello all,
i'm using PHP and MS ACCESS database now i'm updating the table in a while loop. but it is giving error like...
Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement., SQL state 37000 in SQLExecDirect in c:\apache\htdocs\allocater.php
and my update query is look like this....
$update = "UPDATE allocate3 SET WORKSHEDULE='$work',TIME='$now_date' WHERE auto_id='$id'";
$sql_result = odbc_exec($conn,$update);
what may be the problem please help me regarding this????
i'm using PHP and MS ACCESS database now i'm updating the table in a while loop. but it is giving error like...
Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement., SQL state 37000 in SQLExecDirect in c:\apache\htdocs\allocater.php
and my update query is look like this....
$update = "UPDATE allocate3 SET WORKSHEDULE='$work',TIME='$now_date' WHERE auto_id='$id'";
$sql_result = odbc_exec($conn,$update);
what may be the problem please help me regarding this????