Merge data into one?
I have this table output I'm using only inner join.
Name | Jan | Feb | Mar | Year |
Name_1 | 0.00 | 0.00 | 10.00 | 2014 |
Name_1 | 0.00 | 10.00 | 0.00 | 2014 |
Name_2 | 10.00 | 0.00 | 10.00 | 2014 |
Name_2 | 0.00 | 10.00 | 10.00 | 2014 |
Name_2 | 0.00 | 10.00 | 0.00 | 2014 |
How can I make it into like this using php or mysql? Merging the same name into one only?
Name | Jan | Feb | Mar | Year |
Name_1 | 0.00 | 10.00 | 10.00 | 2014 |
Name_2 | 10.00 | 10.00 | 10.00 | 2014 |
Table1
Name_ID=PK
Name_ID | Name |
1 | 1 |
2 | 2 |
Table2
Name_ID=FK to Table1.Name_ID
Name_ID=PK
Name_ID | Name_ID2 | Date | PaidAmount |
1 | 1 | 2014-01-01 | 10.00 |
1 | 2 | 2014-02-01 | 10.00 |
2 | 3 | 2014-01-01 | 10.00 |
2 | 4 | 2014-02-01 | 10.00 |
2 | 5 | 2014-03-01 | 10.00 |