Re: Grouping rows in table using jquery or Javascript

[sophen pho]

Hi guy,

Why you don't use group by in SQL statement?

Thank

On Fri, Dec 28, 2012 at 3:29 PM, seyha chroeng <seyha.c...@gmail.com> wrote:

Dear All,

 

How are you so far? I have a question to ask u all

I have created a table on front end with several columns. The table with data looks something like below:

ID         Name          Date1           Date2         Code1    




00001        abc         2012/1/1         2012/1/10       1
00002        def         2012/1/12        2012/2/1        1
00002        def         2012/1/12        2012/2/1        2
00002        def         2012/1/12        2012/2/1        3
00003        xyz         2012/2/12        2012/3/1        2
00003        xyz         2012/2/12        2012/3/1        4





Now I want to present data in above table in grouped manner i.e. every 
unique Id has only 1 row and all the code columns merged and displayed 
as 1 row.

    ID         Name          Date1           Date2         Code1    
   00001        abc         2012/1/1         2012/1/10       1
                                                             1
   00002        def         2012/1/12        2012/2/1        2                              
                                                             3
   00003        xyz         2012/2/12        2012/3/1        2
                                                             4 


If any one know how to do this with javascript or Jquery, plz guide me some tips.




I will appreciate with your help.


Best Regards,

--
Mr Chroeng Seyha Web Developer   
NOKOR Group
Delano Business Center
No. 144, st. 169
7Makara, Phnom Penh
W: www.nokor-group.com
M: +855 77 46 88 77
L: +855 23 992 733

--
Sophen Pho
Web Mobile & Application Developer, Technology and Innovations
Tel: (+855) 97 792 47 21
skype: pspdeveloper
twitter: @pspdeveloper
http://facebook.com/sophen.pho
http://linkedin.com/in/sophenpho
http://gplus.to/sophen