MySQL: Insert else Update

Ever had to check if a record exists using SELECT then perform an INSERT or UPDATE based on the result? Why not combine both the INSERT and UPDATE into one command and remove the SELECT query checking with one easy MySQL feature. Instead of performing two or three queries we can perform just one which
Continue reading...

CSS: Forcing vertical scrollbar

I’ve had issues when designing websites with the website appearing to shift this is a common issue and caused due to the vertical scroll bar (used to move up and down a page) automatically appearing if the page content requires scrolling and disappears when it is not needed. This is not an issue on all
Continue reading...

Whats dropbox & data backups

Gone are the days of hundreds of CD’s and photo albums most of us now have thousands of valuable irreplaceable photos and videos but why do thousands of us never create backup procedures or recovery plans…remember this data is irreplaceable your literally throwing away memories and all the hundreds of pounds you have spent building
Continue reading...

Why won’t my shared web host allow?

Shared web hosting is common and relatively cheap these days pay a small monthly fee from £1 all the way up to £35+ and you can easily setup a website with FTP, database and mail support. The features provided with most shared web hosting these days are varied to some providing hardly any to others
Continue reading...

Website compression should i?

Website compression is an important feature which can help increase a websites loading speed, before you dive straight in you need to understand how it works as it will increase CPU usage which could lead to a web server (especially busy ones) becoming slow resulting in slow website speeds (which could leave you with a
Continue reading...

Oversized images why its a problem

A very common issue on most websites is oversized images, most people tend to just leave it as their website appears to load fast but they never think about other potential visitors they are alienating who don’t have fast internet or mobile internet devices which can take a long time to load depending on signal.
Continue reading...