I have needed to extract information from a MySQL database on a regular basis and present the information in the form of 'business hours'. One of the biggest issues I have had is that whilst the business days and hours are static and can be filtered (see my article: MySQL limiting selection to business hours) The public holidays themselves change and as such I can't simply remove a specific day.In order to get around this, the easiest way I found was to create another table in MySQL to store the public holidays. In my schema, my table contained holidayID, HolidayName, HolidayState and HolidayDate. This allowed me

You've been snapping away with your nifty little point and shoot camera for a while now and you've discovered you really like taking pictures and want to get more creative and have more control over your photos. Naturally the next step is to upgrade to an SLR camera. But which one? There is a ridiculous number of products out there with all sorts of buttons and dials that do this or that. This article attempts to give a brief overview of the things that are actually important

I HATE self portraits, but really wanted to have a try at a low-key image but didn't have a model to try this with. In the end they were underexposed (and i look like a serial killer), but how did you think I went?