danielhpavey.uk

A sorta, kinda, web development and design blog...

Posts tagged #webdev:

Change Last Character in String to Uppercase in MySQL

Thursday 11 February 2016

How to Change the Last Character in a String to Uppercase in MySQL I have been working on a project that required the importing of some nasty old, badly formatted data in a nice new MySQL database. I ended up data in a firstname field with titles and initials, for example; Mr…

Tags: #mysql #webdev

Two Methods for Retaining Div Aspect Ratio

Friday 8 May 2015

Two Methods for Retaining Div Aspect Ratio I recently found that I needed to maintain the aspect ratio of a div as the browser resizes. I wanted to maintain the ratio as I was using it as part of an image slide show. I found 2 good solutions, one seemingly a lot…

Tags: #css #webdev #webdesign