I'm trying to use php to maniupltate an sqlite database using the following code, but it doesn't seem to be running the update query. I'm not getting any error, but the datbase values are not changing.
Can anyone help? <?php error_reporting(E_ALL); $inv=file('audit.txt'); $sesfile = "wtc.sqlite3"; $sesdb = new PDO('sqlite:wtc.sqlite3'); $query="SELECT ZNAME, ZQUANTITY, ZPRODUCTID FROM ZITEM WHERE ZCategory != 14"; $statement= $sesdb->query($query); $result=$statement->fetchAll(); $statement=null; foreach ($result as $product) { $prodname=$product[0]; $prodqty = $product[1]; $prodid=$product[2]; $sql = "UPDATE ZITEM SET ZQUANTITY=0 WHERE ZPRODUCTID={$prodid}"; $sesdb->exec($sql); $sesdb2 = null; } $query="SELECT ZNAME, ZQUANTITY, ZPRODUCTID FROM ZITEM WHERE ZCategory != 14"; $statement2 = $sesdb->query($query); $result2 = $statement2->fetchAll(); echo "<table>"; foreach ($result2 as $product) { echo "<tr><td>".$product[0]."</td><td>".$product[1]."</td><td>". $product[2]."</td></tr>"; } echo "</table>"; ?> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users