Create more views

Still need various "outputs":

• We have "My dives" which leads to a table with all dives, clicking there on "Observed Species" leads to a table with the species recorded on that dive. We also need a table "My observations" which lists all species recorded and next to it a link "Dives on which this species was seen" or something like that, listing in turn all dives with this species.  (should be accessible through the menu "My observations").
• We also should have something that lists all species and where they were found (and by whom?) - an overview of all results, maybe even some graphs on frequency...
• The "my dives" view should also lead to a more detailed view of each dive (depth, dive time, etc, to be used as a log book..)

 
To change the output in tables that depend on views, there is a switch- statement in the code which has to be adjusted accordingly when some new value is added. The files to be adjusted are found in web5.her.hcmr.gr/data/www/diving.her.hcmr.gr/themes/strange_little_town/views/.
 

PROBLEM:

the name of the species cannot be passed as an url parameter to be used in another view, because the name of the species is not a value but a field in the database! Unless there's some neat trick we'll have to either write a module with the sql statement or we have to write a view for every single species with the dives as results...