Currently Browsing: Work

getting a comma separated list in a MySQL Group By statement

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
read more

RIP IE6

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.  ...
read more

reCaptcha VS noCaptcha

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...
read more