February 2009
MonTueWedThuFriSatSun
« Jan Jun »
 1
2345678
9101112131415
16171819202122
232425262728 

Month February 2009

One core, one app, multiple domains for CakePHP

Dealing with configurations for multiple domains (environments) is always a topic for discussion. I wanted to share my way of dealing with this common problem. This will not be right for all, which is the point. If this does not suit you, there are a few links at the bottom.

Finding ordered position of a row in MySQL

This is slightly modified from something I found @ http://www.kirupa.com/forum/archive/index.php/t-263260.html Using high-score lists or similar you often have a large number of rows where you want to know who is in 7th place or how well is id:254 doing. This eliminates the slow looping in php of big result-sets by making a sub-query in MySQL. [...]