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:
Dataset:
ID Marks
1 20
2 30
3 40
Result Required:
IDs Sum(Marks)
1,2,3 90
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.
While using...
