MENU
Coding
Here we list some handy SQL tips that help you combine queries, stop fields being truncated and run scheduled backups … Read More »
Coding
Productivity News
I've had an email address visible on this blog for a while just to see what would happen and.... nothing. No Spam. Nada. I've encrypted it now all the same, but I found it weird that it was never picked up (not that I … Read More »
Coding
It’s taken me ages to find out how to do this (what turns out to be a) relatively simple operation. Here’s the problem. Table 1 has a user_id which is auto incremented by MYSQL. Table 2 has an auto incremented login_id but also requires … Read More »
Coding
I’ve been writing an application for work that requires me to display one weeks worth of data, starting on a Monday and ending on a Sunday. Below is the code that will find the first Monday and subsequent days dates. This code would be … Read More »
Websites & Blogging
It was quite by accident I noticed that a couple of posts on this blog had over 50 comments. “Wow!” I thought to myself, “I must be getting really popular!“. Sadly not, they were all posts from “robots” sent to automatically submit dubious entries … Read More »