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