[mapserver-users] A question about mysql

[Steve Lime]

At present you need a small helper script to do this and a common field
in your database and shapefile.
Then you just use a URL template like so:

  TEMPLATE
"http://myserver.com/cgi-bin/helper_script?keyfield=[KEYFIELD]"

The helper script takes the information about the feature you clicked
on and actually does the MySQL
query, formating and so on. The helper script could leverage query maps
and other MapServer output
too.

Steve

Stephen Lime
Data & Applications Manager

Minnesota DNR
500 Lafayette Road
St. Paul, MN 55155
651-297-2937

>>> <klehr1 at tampabay.rr.com> 01/25/02 09:29AM >>>
I'm running mapserver and mysql as well and would love to look at
sniplet of
a map file that shows how to connect to mysql, and execute a small
query via
the mapserver cgi application.

Thanks
Steve Lehr

----- Original Message -----
From: Nacho Benito <nachobenito75 at hotmail.com>
To: <mapserver-users at lists.gis.umn.edu>
Sent: Friday, January 25, 2002 4:23 AM
Subject: [mapserver-users] A question about mysql


Hi everybody!
I'm just starting with MapServer and I'd like to know if it's possible
to
link with Mysql database, I have the geographical information in .shp
files
and I'd like to improve the amount of data I could show in the map (I
suppose it's possible but I'm not absolutely sure)
Anyone can tell me where I could find some information?
sorry if my english is not very good but I'm spanish and I'm doing my
best
Thanks in advance (any help will be welcome)
Nacho


_________________________________________________________________
Hable con sus amigos en línea, pruebe MSN Messenger:
http://messenger.msn.es