UPDATE query is not working

Sujit Joshi · July 4th, 2005, 06:15 AM

hello all, i'm new to this forum i have bigginner level experience..
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????

happygv · July 6th, 2005, 04:07 PM

This is how it should look. Do a echo $update just after this red line, and see what it contains.

Code:

$update = "UPDATE allocate3 SET WORKSHEDULE='" . $work . "',TIME='" . $now_date . "' WHERE auto_id='" . $id . "'";
$sql_result = odbc_exec($conn,$update);

Hope that helps.

_________________________
- Vijay G
Strive for Perfection