Posted by Prince in Work on Oct 7th, 2011 | 0 comments
If you are combining several rows in a MySQL query using a GROUP BY statement and still want to get a comma separated list of all the values of a particular column…
something like below:
you should be using the GROUP_CONCAT function of MySQL. Check out more of it at MySQL official documentation
Posted by Prince in Fun, Work on Feb 24th, 2010 | 2 comments
Internet Explorer Six, resident of the interwebs for over 8 years, died the morning of March 1, 2010 in Mountain View, California, as a result of a workplace injury sustained at the headquarters of Google, Inc. Internet Explorer Six, known to friends and family as “IE6,” is survived by son Internet Explorer Seven, and grand-daughter Internet Explorer Eight. Funeral services for Internet Explorer Six will be held at 7pm on March 4 at Aten Design Group, 1629 Downing Street, Denver, CO 80218.
Taken from ie6funeral.com. Check out http://ie6funeral.com/ for full details.
Posted by Prince in Work on Dec 9th, 2009 | 3 comments
My web developer friends must be knowing what captcha is so they can carry on to the next paragraph however for the not so familiar audiences the captcha is that extra field you encounter when filling a form on the web where some characters are embedded in the picture and you have to enter the characters in the textbox….It is basically used to identify humans… oh not that we have aliens living among us.. but we do have automated scripts and robots on the web specifically created to spread spam and create unwanted links or even sometimes trying to hack the websites or systems.
Posted by Prince in Life, Thoughts on Jan 21st, 2009 | 1 comment
I want it big. From an extraordinarily big house ( surrounded with big walls of loneliness on which I can bang my head when I actually realize it), to a real-big bank account (the cash in which would be used to treat my loneliness ofcourse), to an awesome swanky big new Merc (so that when I am drunk I can drive over those nuts and bolts who after the day has screwed them get nothing but a footpath to sleep). I am sure you would be interested in watching my big plasma tv ( the idiot box, with which it seems that we have switched places, idiot) or how about a big office (ofcourse the slums there were...