t_test
id | mtype | ntype | qtype|
1 | 1 |1 |1 |
2 | 2 |2 |2 |
3 | 3 |3 3 |
4 | 4 |4 |5 |
5 | 5 |1 |3 |
6 | 2 |2 |1 |
7 | 2 |1 |1 |
8 | 3 |1 |1 |
9 | 1 |1 |1 |
10 | 1 |1 |1 |
数据库表如上:
要求得到结果在页面上显示为
mtype ntype qtype
1(30%) 1(60%) 1(60%)
2(30%) 2(20%) 3(20%)
3(20%) (其他20%) 其他(20%)
其他(20%)