Diving | Log Book | Stats



Some graphs


This page started as a way of generating the dive stats image at the top of the page, which I use as my signature for diving forums. The image is made by taking some details from the dive log database (bit of PHP and MySQL) and adding a photo from my flickr account from the most recent dive (using phpflickr).

Once I had the image generator up and running I wondered what statistics I could pull out of my database (that is what they're good for after all). * Some of the stats won't be accurate, for example warmest dive should really read: "Warmest dive I was wearing my Citizen Dive Watch which records water temperature and I happened to note the temperature down in my log book". If this page serves no other purpose it will have improved my knowledge of MySQL queries.

If you can think of any more statistics I could pull from my database please let me know via the guestbook.