Re: Sqlite 3 pdo update query problem
| From: | Evert Lammerts | Date: | Wed, 20 Aug 2008 08:59:13 +0000 |
| Subject: | Re: Sqlite 3 pdo update query problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45226@lists.php.net to get a copy of this message | ||
> $sql = "UPDATE ZITEM SET ZQUANTITY='0' WHERE
> ZPRODUCTID='".$prodid."'";
Try to unquote $prodid:
$sql = "UPDATE ZITEM SET ZQUANTITY='0' WHERE ZPRODUCTID={$prodid}";
Evert