[postgis-users] Quote problem in query

[Barend Köbben]

I am not sure about PhP (never use it myself), but in most script and programming langauges I do know, you can 'escape' the quote , usually by putting a \ in front, so your string could be 

" WHERE table.id =  other_table.id AND table.name = \"Algeria\") AS   foo USING UNIQUE uid USING srid=-1"

If this does not work, check a PhP tutorial/book on how to escape characters in strings...


--
Barend Köbben
International Institute for Geo-information 
Sciences and Earth Observation (ITC) 
PO Box 6, 7500AA Enschede (The Netherlands)
ph: +31 (0)53 4874253; fax: +31 (0)53 4874335