Preserving ordering with WHERE IN() clause in MySQL
Today I ran into the code that pulls from database list of elements with SELECT * FROM table WHERE id IN(2,5,3,16,22,56,48) where order of ids is important to be preserved after results found. When using SELECT this way you will get the results for every id but ordered by id in ascending order. I was looking around and found neat solution to make MySQL work for you to preserve the order of returned results. With ORDER BY FIELD clause like here SELECT * FROM table WHERE id IN (1,5,2,13,4) ORDER BY FIELD(id, 1,5,2,13,4) you can keep the initial ordering.
From CakePHP to Zend Framework
It was years ago when I started coding first PHP pages. What a mess was that :) I was beginner, web development was not at the level it is today. The web development tools offer was scarce, AJAX was not so far future but again it was the future :) And beside all of that we were still coding, rushing towards new technologies and development methodologies.
Bowling for bananas
Yesterday we had team building event, organized by our company. I have updated my web albums from Belgrade with new pictures from the event. I scored 114 points, I'm not sure is it good or bad score, but if I need an excuse, IT WAS MY FIRST TIME. Can see the pictures here
Setting Drupal as blogging platform
It is true that Drupal was not my first decision when it comes to blogging platforms. Wordpress was. But, after thinking about reciprocity that tells "More automation - less flexibility" I decided to get to the more hard way. Since I'm internet deveoper quite a time, and have a lot of experience with different web technologies I downloaded Drupal version 5.7 and started with installation, module settings, SEO tunning ... and writing first posts. in this article you can find out some basic steps to create Drupal based personal blog.
Why blogging @ all
Will one new blog make a difference between millions of other on the net.
Well, it depends on the point of view, for you, maybe it can be just couple of minutes waisted , but from my point of view it is not just like that.
First, I forget things, and I need one convenient way to organize things I face during my everyday work. Aside from that it is good to have some kind of feedback from visitors and to check the reality among others that usually have much more to say in comparison to my humble opinions.
