[Mapserver-users] MapServer - is this possible?

[Paul Ramsey]

Mapserver has some simple joining capability wrt DBF files, but I do not 
think anything with a live DBMS. Probably we should be looking at the 
generalized problem for all attribute data sources.
In the simple case, you can do up a join using mapscript. It is nasty 
code, but basically, you first query the database, figure out which 
class each polygon should be in, then write up a class rule for each 
polygon to give it the appropriate color. Then render. Ouch. But it 
works, for maps with small numbers of polygons.
P.

Geoffrey Rowland wrote:

> I'm new to using MapServer, and have a couple of questions.  I have some 
> data stored in a MySQL database, state, county, and then a number (which 
> is related to the county).  Now what I want to do is have MapServer 
> display an ArcView shapefile of the United States (county level), and 
> then use PHP + MapScript to query the database and then color each 
> county based on what the number is in the database. Is that possible?
> 


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_