PostgreSQL - parse error at or near "table"
| From: | Richard Lynch | Date: | Tue, 20 Jun 2000 03:15:59 +0000 |
| Subject: | PostgreSQL - parse error at or near "table" | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-508@lists.php.net to get a copy of this message | ||
Grrrr. Hit some combination of keys that apparently means "send"... Sorry.
I'm seeing this:
select name from entities where id = 7
Warning: PostgresSQL query failed: ERROR: parser: parse error at or near
"table" in /admin/editartist.htm on line 243
Could not execute query
select name from entities where id = 7
and the relevant lines are:
$query = "select name from entities where id = $entityid";
echo $query, "<BR>\n";
$name = pg_exec($conn, $query) or die("Could not execute
query<BR>\n$query<BR>\n");
Huh? What "table"? Where? The permissions are good, and I've already
executed similar queries on earlier pages using:
$query = "select name, website from entities where id = $entityid";
$artist = pg_exec($conn, $query) or die("Could not execute
query<BR>\n$query<BR>\n");
Worked just fine.
So the table itself is okay, I reckon. And this message usually includes
text from the actual query, but "table" is not in the query...
Any ideas?
Please cc me direct -- I mostly hang out on General and Zend forums...