aeshanw
-
Posts
2 -
Joined
-
Last visited
Never
aeshanw's Achievements
Newbie (1/5)
0
Reputation
-
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!"; }
-
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!