Re: quotes in SQL command
| From: | Stefan Neufeind | Date: | Mon, 08 Dec 2003 05:19:15 +0000 |
| Subject: | Re: quotes in SQL command | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-9349@lists.php.net to get a copy of this message | ||
On 8 Dec 2003 at 13:19, Nguyen Hung Vu ST wrote:
> Hello all,
>
> I tried to do an SELECT in PEAR:DB like below
>
> $sth = $db_pear->prepare("SELECT * FROM lists WHERE ID = ?");
>
> but the problem is, that is OK for MySQL but in PostgreSQL, we will
> have
> to put ID inside double quotation ("), and it becomes
>
> $sth = $db_pear->prepare("SELECT * FROM lists WHERE \"ID\" = ?");
>
> That is my problem when I tried to make my program works on both MysQL
> and PostgreSQL.
>
> Any ideas?
Why not use single-quotes around the string?
'SELECT * FROM lists WHERE "ID" = ?'
Regards,
Stefan