[Mapserver-west] mapserver & mysql

[Dylan Keon]

On 11/07/2006 03:16 PM, Nelson Guda wrote:
> Hi all,
> 
> We're working on a map-based database, and the server we have to work 
> with only has support for mysql.  Is there going to be support for mysql 
> anytime soon?  We're just plotting points, but we need to have a query 
> statement in the mapfile layer which can be customized with each url 
> call.  Is that possible now, like it is with postgre?

Hi Nelson,

It is not possible to embed a MySQL query in a mapfile layer definition, 
such as with PostgreSQL/PostGIS, but you can still do some fancy dynamic 
mapping tricks.  Are you using the mapserv CGI or some form of MapScript 
(PHP, Perl, etc.)?  With MapScript and the associated scripting language 
you could modify your query dynamically and access information stored in 
any common RDBMS.  Such as using lon/lat coordinates extracted from 
MySQL to dynamically generate and render point shapes on your map.

--Dylan