Nope, still doesn't work...for the moment I'll just preset the variables
and use double quotes for the query string. The actual insert statement
should be like this:
INSERT INTO gtest VALUES (city, GeomFromText('POINT(lon lat)', 4326))
where lon and lat are decimal numbers, and I wanted to rep
[EMAIL PROTECTED] wrote:
Hi,
I'm trying to set up a prepared sql statement with 3 parameters and then
execute with array of 3 elements (this is to a postgresql database with
postgis):
$result = pg_prepare($dbconn, "my_query", 'INSERT INTO gtest VALUES ($1,
GeomFromText(\'POINT($2 $3)\', 4326
Hi,
I'm trying to set up a prepared sql statement with 3 parameters and
then execute with array of 3 elements (this is to a postgresql
database with postgis):
$result = pg_prepare($dbconn, "my_query", 'INSERT INTO gtest VALUES ($1,
GeomFromText(\'POINT($2 $3)\', 4326))');
$result = pg_exec
