One of the sites that I'm working on at the moment requires some IP-specific functionality, but in testing I realised that the standard $_SERVER['REMOTE_ADDR'] wasn't being as accurate as I wanted.

This is a really quick "howto" guide based on experience in the office, where we had pages and queries that were unable to run properly, purely because of the number of queries that we were trying to pass to MySQL at once.

The MySQLD process was refusing any more than …