quotes in SQL command
| From: | Nguyen Hung Vu ST | Date: | Mon, 08 Dec 2003 04:19:48 +0000 |
| Subject: | quotes in SQL command | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-9348@lists.php.net to get a copy of this message | ||
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?
--
Nguyen Hung Vu
http://sinetechnologies.com/