Re: Sqlite 3 pdo update query problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Amy Gibbs" <amy@xxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Sqlite 3 pdo update query problem
From: "Evert Lammerts" <evert.lammerts@xxxxxxxxx>
Date: Wed, 20 Aug 2008 10:59:13 +0200
Cc: php-db@xxxxxxxxxxxxx
In-reply-to: <D008FE9E-BBAA-4B1C-A854-42A97323B73E@xxxxxxxxxxxxxxxxxxxxxx>

> $sql = "UPDATE ZITEM SET ZQUANTITY='0' WHERE ZPRODUCTID='".$prodid."'";

Try to unquote $prodid:

$sql = "UPDATE ZITEM SET ZQUANTITY='0' WHERE ZPRODUCTID={$prodid}";

Evert

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Follow-Ups:
- Re: Sqlite 3 pdo update query problem
  - From: Amy Gibbs

References:
- Sqlite 3 pdo update query problem
  - From: Amy Gibbs

Prev by Date: Sqlite 3 pdo update query problem
Next by Date: Re: Sqlite 3 pdo update query problem
Previous by thread: Sqlite 3 pdo update query problem
Next by thread: Re: Sqlite 3 pdo update query problem
Index(es):
- Date
- Thread

[Index of Archives] [PHP Home] [PHP Users] [Postgresql Discussion] [Kernel Newbies] [Postgresql] [Yosemite News]

Powered by Linux