How to get/use a Query Result for further processing?

[BONNER S KARGER]

I've been trying to do this with PHP, and have not found a good way as of yet (or any successful way). You can process query results on the query template, but not on the mapping page that gets sent to the CGI...for example, the PHP code would not be processed when sent to the CGI.

If you find a way to do it (whether it be javascript or otherwise), please enlighten me!
Thank you

-------------------------------------
Bonner Karger
Soils Extension, UW-Madison
1525 Observatory Drive
Madison, WI 53706
(w) 608-262-9969
bskarger at wisc.edu
http://www.soils.wisc.edu/extension/

----- Original Message -----
From: "Renato F. Salas" <rsalas at VOXIVA.NET>
Date: Friday, August 20, 2004 12:47 pm
Subject: [UMN_MAPSERVER-USERS] How to get/use a Query Result for further processing?

> Hi, I'm just new to MapServer/PostGIS. I've setup the tutorial and
> havea running application using the CGI-BIN mapserver executable.
>
> As far as I know I can only make queries and display the results
> on a
> Template with the appropriate tags that just point to the columns
> on the
> table where the geometries (the_geom) data resides.
>
> What I would like to do is to get the result somehow (just the ID of
> the_geom) for doing something else, like generating a SELECT on a
> related table using PostgreSQL/PostGIS to show, say, all the reported
> cases in that particular point, with pictures, sounds, and more stuff
> not available in the geom table. For doing that I'd probably use a
> scripting language like ASP or PHP.
>
> I think this should be a trivial scenario but I can't find any
> documentation on the web. I would like to avoid using
> PHP/Mapscript just
> to keep it simple.  Any ideas would be appreciated.
>
> Thanks a lot,
>
> Renato F. Salas
>
> PD: Is there any book on MapServer?. I find myself browsing the
> web a
> lot to get simple answers. There should be one consistent place to go
> from the basics to the advanced topics.
>