Trying to do an update with the following code:
$query=odbc_exec($odbc, " UPDATE phpInventory set NumberOnHand=$NumberUsed WHERE

ControlNumber like '$%ControlNumber%' and PartNumber like '$%PartNumber%' ");
$result = odbc_exec($odbc,$query);

I have verified that the connection string works(which is in an include statement)


Getting the following error: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'., SQL state 37000 in SQLExecDirect in d:\inetpub\wwwroot\sparepartsinv\action3.php on line 16

Hi, you've got a space before 'UPDATE'. is that meant to be there?

thanks that did it