SELECT WEEK(my_date_field,5) - WEEK(DATE_SUB(my_date_field, INTERVAL DAYOFMONTH(my_date_field)-1 DAY),5)+1 Recently I needed to get the number of the week in a certain month. There is the handy WEEK() function, however it only gives you the week of
It sounds like a simple task – retrieve the result from a join SQL query. Unusually you can even find documentation on the official Zend Framework site explaining how to put together a query that will return the results from a JOIN query. Unfortunately when it actually comes to putting theory
One day while looking for shoes in Camden (where else would you go looking for fancy shoes, when you prefer a Not So GirlyAvoid Heels Style…) in London we were browsing through several stores and goofing around a bit. In one of the shops I happened to find an advert
For a recent project I was wanting to perform an exceptionally common task. Converting things that look like URLs in the text into clickable links. However wherever I’ve seen this implemented before I’ve always encountered the same annoying problem, namely the links break when the user types a
While on Easter holiday at my parents home we have been going out for daily walks. Living in the countryside has the definite benefit of enjoying some rare sights. Just to mark to really nice encounters – a couple of storks and a pack of young deer I’m giving away