MS ACCESS ODBC Update doesnt work

[aeshanw]

I'm trying to use PHP with an MS Access but Im having problesm with this UPDATE statment.

odbc_exec($odbc, "UPDATE tblProducts SET subCatId='$subCat' WHERE ProdNo='$id'");

Any idea why?thanks!

 

[aeshanw]

Here's more code if u'd like to know how I used it.

if(isset($_POST['Submit']))

{

 

$subCat = $_POST['subCat'];

$check = $_POST['check'];

 

foreach($check as $id){

if(odbc_exec($odbc, "UPDATE tblProducts SET subCatId='$subCat' WHERE ProdNo='$id'")){

echo "<br>UPDATE SUCCESS!";

}else{

echo "<br>UPDATE FAILED!";

}

}

echo "UPDATE COMPLETE!";

}