pg_exec error

[Randy James]

Hi
I am having trouble with inserting a veriable with the GeometryFromText function,
this the line that causes an error;

pg_exec($connection, "INSERT INTO sites VALUES
('$q_nxt_gid','$id','$label','$site_id','$comments',GeometryFromText('POINT('$pointx'
'$pointy')',-1)");

It produces this error, (Note; 575618 is the $pointx variable).

Warning: pg_exec(): Query failed: ERROR: syntax error at or near "575618" at
character 88 in /var/www/html/gis/create/write_postgres.phtml on line 19

Thanks for any help i can get.


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com