How can i symbolize a map dynamically by data stored in mysql database in many tables (these tables have relationship through Primary Key and FK)

Question

How can i symbolize a map dynamically by data stored in mysql database in many tables (these tables have relationship through Primary Key and FK). For instance "Disease Name"(chosen from drop down then "Affected Number" (from another drop down) "Sex" (to chosen from another drop down) then "Year" from another drop down box, after all an ok button to be hit to produce intended map. I am using geoserver 2.2 postgresql( postgis). I am try to outline the process but ended in smoke (my first design and so so), would any one ,as samaritan ,help me, plz. Thanks in advance.

my project is as in https://docs.google.com/open?id=0B1NvUoakjNxwZ0VGSm15bE9fNkE

Answer 1

If you just need to change the symbology (i.e.: use blue for men and pink for women) an option is using variable substitutions in SLDs as described in the Geoserver documentation.

The idea is that you should be able to customize the rendering by passing additional custom params to the GetMap requests (with the OpenLayers.Layer.WMS.mergeNewParams function).

If variable substitution is not powerful enough than you could use one of the dynamic SLD options available with Geoserver.

If you only need to filter the dataset depending on user selection you can use CQL filters instead.