Update Field Error
Fatal error:uncaught exception ' com_exception ' with message '
Source:Microsoft OLE DB Provider for ODBC Drivers
Description:[Microsoft] [ODBC Microsoft Access Driver] Syntax error for UPDATE statement. ' In D:\workspace\php\alalan\adminalila\infoli\list_px.php:12 Stack trace: #0 D:\Workspace\PHP\alalan\adminalila\ infoli\list_px.php: Com->execute (' Update info set ... ') #1 {main} thrown in D:\Workspace\PHP\alalan\adminalila\ Infoli\list_px.php on line 12
if (@$_request["Top"]!= "") {
$top =@$_request["Top"];
if (Is_numeric ($top)) {
$SQLCP = "Update info set top=". $top. "Where id=". $_request["id"]; $conn->execute ($SQLCP);
}else{
ShowMsg ("character is incorrect! Only numbers can be entered!! "," list_px.php?wz= ". @$_request[" WZ "]." &page= ". @$_request[" page "].");
}
}
?>
------Solution--------------------
Because top is a SQL statement built-in Word with like, order almost as a field to add ' number like ' top ' = ...
------Solution--------------------
Wasn't he suggesting that the SQL instructions were wrong?
You print it out and see
