P2Pprogrammer 2 programmer

Home > Programmer2Programmer.NET Forum> ASP.NET and Web Development >> how to get rid of repeating row labels in mysql query result set...

Welcome Guest My Thread | Search | Active Topics | Members | Log In | Register

NOTE : Log In required to post Replies for this discussion.
how to get rid of repeating row labels in mysql query result set
Waseem Posted: Monday 29, July 2019 02:43:57 AM     
   
I have two tables named customers with primary key cid and inst
allment with foreign key cid. i join both table. Result set con
tains repeating items labels.But i want result set do not conta
in repeating items labels. explanation as under
custom table
cid         name              cell
12         Ramzan             033333
15         zahid              034444
21         Shahid             035222

installment table

cid        amount             date
12         1500              12-05-19
15         1500              13-05-19
12         1500              15-05-19
15         1500              17-05-19
21         2000               20-05-19

Resultant table

cid        name         cell     date      amount
12        Ramzan        03333    12-5-19     1500
12        Ramzan        03333    15-05-19    1500
15        Zahid         03444    13-05-19    1500
15        Zahid         03444    17-05-19    1500
21        Shahid        035222   20-05-19    2000
                            

But i want to get this resultant Table

cid        name         cell     date      amount
12        Ramzan        03333    12-5-19     1500
                                 15-05-19    1500
15        Zahid         03444    13-05-19    1500
                                 17-05-19    1500
21        Shahid        035222   20-05-19    2000
                            total            8000

But i want to get this resultant Table

cid        name         cell     date      amount
12        Ramzan        03333    12-5-19     1500
                                 15-05-19    1500
15        Zahid         03444    13-05-19    1500
                                 17-05-19    1500
21        Shahid        035222   20-05-19    2000
                            total            8000
Back to Top ^  













Home > Programmer2Programmer.NET Forum >ASP.NET and Web Development >> how to get rid of repeating row labels in mysql query result set...