SQL Archive
Creating 50,000 unique values
A client at work wants to run a promotion where a customer will receive a card with a unique 8 digit code on it when they buy something. They will then be able to visit the website to find out if they are a winner or to get a chance...
Read More A Quick Tip
I haven't written anything here for ages due to illness, work and life getting in the way. I've got a longer post brewing that I'll hopefully add in the next couple of days but for now here's a quick tip that I hope someone will find useful.
I recently had a...
Read More Handling Binary Data with PDO
I'm a great fan of the PDO database access library in PHP 5 and use it for all of my database work in PHP. I love its' clean, object oriented syntax and great support for prepared statements. I also like the fact that it supports most of the most common database...
Read More Location Aware Webpages
I'm working on a site for a client at the moment who has around 35 store locations across Canada. The client was keen to have a 'your local store' feature on the home page where the store closest to the visitors location was featured. I thought I'd write briefly about...
Read More 
