SELECT WEEK(my_date_field,5) -
WEEK(DATE_SUB(my_date_field, INTERVAL DAYOFMONTH(my_date_field)-1 DAY),5)+1
Archive for April, 2009
Home »
Archive for April, 2009
26Apr
2009
2009
Week of the Month in Mysql
22Apr
2009
2009
Zend_Db_Select multiple table joins explained
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 into practice any Zend newcomer can run into several problems. (more…)
13Apr
2009
2009
Regex for Autolinking URLs
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 URL and adds some punctuation at the end since the punctuation gets captured as part of the link.
Categories:
12Apr
2009
2009
Blog Revamp Complete
Finally the new design is here. Fresh, and might have a few glitches here and there (still struggling with some WP 2.7 bits and pieces).
The whole redesign process has made me swear heavily at the dreaded IE 6 browser many times. I really have to admit I holeheartedly agree with the notion of shooting it dead.
But nevertheless, enjoy the new clean design.
