我正在做一个学生成绩排名的功能，导入原生成绩数据（语文、数学、英语、物理、化学、生物、历史、地理、政治）然后计算出每位同学的各科班级排名和各科年级排名情况，后期支持导出数据（原生成绩+成绩单科班级排名+成绩单科年级排名）。
举例
| 考号 | 年级 | 班级 | 语文 | 语文班名次 | 语文级名次 |
|---|---|---|---|---|---|
| 1 | 1 | 1 | 70 | ||
| 2 | 1 | 2 | 80 | ||
| 3 | 1 | 2 | 90 | ||
| 4 | 1 | 1 | 70 | ||
| 5 | 1 | 2 | 80 | ||
| 6 | 1 | 3 | 81 | ||
| 7 | 1 | 1 | 70 | ||
| 8 | 1 | 2 | 80 | ||
| 9 | 1 | 3 | 90 | ||
| 10 | 1 | 1 | 70 | ||
| 11 | 1 | 2 | 80 | ||
| 12 | 1 | 2 | 90 | ||
| 13 | 1 | 1 | 70 | ||
| 14 | 1 | 3 | 81 | ||
| 15 | 1 | 2 | 90 |
-
排名是在导入数据时php处理，还是导入原始数据后再用mysql处理，给一个示例一下，谢谢
-
相同分数名次相同如何处理
补充一个php做的分数排序，如何和排名序号结合起来？同分一样如何处理呢？（为了自己认识全是中文键名）
yuwenji:语文分数年级排序
yuwenban[1]:1班语文分数排序
依次类推
<code class="php">Array( [yuwenji] => Array ( [111111000000000009] => 60 [111111000000000008] => 60 [111111000000000011] => 60 [111111000000000012] => 60 [111111000000000013] => 60 [111111000000000007] => 60 [111111000000000006] => 60 [111111000000000002] => 60 [111111000000000001] => 60 [111111000000000003] => 60 [111111000000000004] => 60 [111111000000000005] => 60 [111111000000000010] => 60 ) [yuwenban] => Array ( [2] => Array ( [111111000000000009] => 60 [111111000000000011] => 60 [111111000000000004] => 60 [111111000000000003] => 60 [111111000000000002] => 60 [111111000000000010] => 60 ) [1] => Array ( [111111000000000008] => 60 [111111000000000007] => 60 [111111000000000006] => 60 [111111000000000005] => 60 [111111000000000001] => 60 ) [3] => Array ( [111111000000000013] => 60 [111111000000000012] => 60 ) ) [shuxueji] => Array ( [111111000000000009] => 65 [111111000000000008] => 65 [111111000000000011] => 65 [111111000000000012] => 65 [111111000000000013] => 65 [111111000000000007] => 65 [111111000000000006] => 65 [111111000000000002] => 65 [111111000000000001] => 65 [111111000000000003] => 65 [111111000000000004] => 65 [111111000000000005] => 65 [111111000000000010] => 65 ) [shuxueban] => Array ( [2] => Array ( [111111000000000009] => 65 [111111000000000011] => 65 [111111000000000004] => 65 [111111000000000003] => 65 [111111000000000002] => 65 [111111000000000010] => 65 ) [1] => Array ( [111111000000000008] => 65 [111111000000000007] => 65 [111111000000000006] => 65 [111111000000000005] => 65 [111111000000000001] => 65 ) [3] => Array ( [111111000000000013] => 65 [111111000000000012] => 65 ) ) [englishji] => Array ( [111111000000000009] => 99 [111111000000000008] => 99 [111111000000000011] => 99 [111111000000000012] => 99 [111111000000000013] => 99 [111111000000000007] => 99 [111111000000000006] => 99 [111111000000000002] => 99 [111111000000000001] => 99 [111111000000000003] => 99 [111111000000000004] => 99 [111111000000000005] => 99 [111111000000000010] => 99 ) [englishban] => Array ( [2] => Array ( [111111000000000009] => 99 [111111000000000011] => 99 [111111000000000004] => 99 [111111000000000003] => 99 [111111000000000002] => 99 [111111000000000010] => 99 ) [1] => Array ( [111111000000000008] => 99 [111111000000000007] => 99 [111111000000000006] => 99 [111111000000000005] => 99 [111111000000000001] => 99 ) [3] => Array ( [111111000000000013] => 99 [111111000000000012] => 99 ) ) [wuliji] => Array ( [111111000000000009] => 99 [111111000000000008] => 99 [111111000000000011] => 99 [111111000000000012] => 99 [111111000000000013] => 99 [111111000000000007] => 99 [111111000000000006] => 99 [111111000000000002] => 99 [111111000000000001] => 99 [111111000000000003] => 99 [111111000000000004] => 99 [111111000000000005] => 99 [111111000000000010] => 99 ) [wuliban] => Array ( [2] => Array ( [111111000000000009] => 99 [111111000000000011] => 99 [111111000000000004] => 99 [111111000000000003] => 99 [111111000000000002] => 99 [111111000000000010] => 99 ) [1] => Array ( [111111000000000008] => 99 [111111000000000007] => 99 [111111000000000006] => 99 [111111000000000005] => 99 [111111000000000001] => 99 ) [3] => Array ( [111111000000000013] => 99 [111111000000000012] => 99 ) ) [huaxueji] => Array ( [111111000000000009] => 99 [111111000000000008] => 99 [111111000000000011] => 99 [111111000000000012] => 99 [111111000000000013] => 99 [111111000000000007] => 99 [111111000000000006] => 99 [111111000000000002] => 99 [111111000000000001] => 99 [111111000000000003] => 99 [111111000000000004] => 99 [111111000000000005] => 99 [111111000000000010] => 99 ) [huaxueban] => Array ( [2] => Array ( [111111000000000009] => 99 [111111000000000011] => 99 [111111000000000004] => 99 [111111000000000003] => 99 [111111000000000002] => 99 [111111000000000010] => 99 ) [1] => Array ( [111111000000000008] => 99 [111111000000000007] => 99 [111111000000000006] => 99 <mark>6来源gaodaimacom搞#^代%!码网</mark><strong>搞gaodaima代码</strong> [111111000000000005] => 99 [111111000000000001] => 99 ) [3] => Array ( [111111000000000013] => 99 [111111000000000012] => 99 ) ) [shengwuji] => Array ( [111111000000000009] => 99 [111111000000000008] => 99 [111111000000000011] => 99 [111111000000000012] => 99 [111111000000000013] => 99 [111111000000000007] => 99 [111111000000000006] => 99 [111111000000000002] => 99 [111111000000000001] => 99 [111111000000000003] => 99 [111111000000000004] => 99 [111111000000000005] => 99 [111111000000000010] => 99 ) [shengwuban] => Array ( [2] => Array ( [111111000000000009] => 99 [111111000000000011] => 99 [111111000000000004] => 99 [111111000000000003] => 99 [111111000000000002] => 99 [111111000000000010] => 99 ) [1] => Array ( [111111000000000008] => 99 [111111000000000007] => 99 [111111000000000006] => 99 [111111000000000005] => 99 [111111000000000001] => 99 ) [3] => Array ( [111111000000000013] => 99 [111111000000000012] => 99 ) ) [lishiji] => Array ( [111111000000000013] => 81 [111111000000000012] => 80 [111111000000000011] => 79 [111111000000000009] => 78 [111111000000000008] => 77 [111111000000000007] => 76 [111111000000000006] => 75 [111111000000000005] => 74 [111111000000000004] => 73 [111111000000000003] => 72 [111111000000000002] => 71 [111111000000000001] => 70 [111111000000000010] => 69 ) [lishiban] => Array ( [2] => Array ( [111111000000000011] => 79 [111111000000000009] => 78 [111111000000000004] => 73 [111111000000000003] => 72 [111111000000000002] => 71 [111111000000000010] => 69 ) [1] => Array ( [111111000000000008] => 77 [111111000000000007] => 76 [111111000000000006] => 75 [111111000000000005] => 74 [111111000000000001] => 70 ) [3] => Array ( [111111000000000013] => 81 [111111000000000012] => 80 ) ) [diliji] => Array ( [111111000000000013] => 81 [111111000000000012] => 80 [111111000000000011] => 79 [111111000000000009] => 78 [111111000000000008] => 77 [111111000000000007] => 76 [111111000000000006] => 75 [111111000000000005] => 74 [111111000000000004] => 73 [111111000000000003] => 72 [111111000000000002] => 71 [111111000000000001] => 70 [111111000000000010] => 69 ) [diliban] => Array ( [2] => Array ( [111111000000000011] => 79 [111111000000000009] => 78 [111111000000000004] => 73 [111111000000000003] => 72 [111111000000000002] => 71 [111111000000000010] => 69 ) [1] => Array ( [111111000000000008] => 77 [111111000000000007] => 76 [111111000000000006] => 75 [111111000000000005] => 74 [111111000000000001] => 70 ) [3] => Array ( [111111000000000013] => 81 [111111000000000012] => 80 ) ) [zhengzhiji] => Array ( [111111000000000013] => 81 [111111000000000012] => 80 [111111000000000011] => 79 [111111000000000009] => 78 [111111000000000008] => 77 [111111000000000007] => 76 [111111000000000006] => 75 [111111000000000005] => 74 [111111000000000004] => 73 [111111000000000003] => 72 [111111000000000002] => 71 [111111000000000001] => 70 [111111000000000010] => 69 ) [zhengzhiban] => Array ( [2] => Array ( [111111000000000011] => 79 [111111000000000009] => 78 [111111000000000004] => 73 [111111000000000003] => 72 [111111000000000002] => 71 [111111000000000010] => 69 ) [1] => Array ( [111111000000000008] => 77 [111111000000000007] => 76 [111111000000000006] => 75 [111111000000000005] => 74 [111111000000000001] => 70 ) [3] => Array ( [111111000000000013] => 81 [111111000000000012] => 80 ) ) [wenzongji] => Array ( [111111000000000013] => 243 [111111000000000012] => 240 [111111000000000011] => 237 [111111000000000009] => 234 [111111000000000008] => 231 [111111000000000007] => 228 [111111000000000006] => 225 [111111000000000005] => 222 [111111000000000004] => 219 [111111000000000003] => 216 [111111000000000002] => 213 [111111000000000001] => 210 [111111000000000010] => 207 ) [wenzongban] => Array ( [2] => Array ( [111111000000000011] => 237 [111111000000000009] => 234 [111111000000000004] => 219 [111111000000000003] => 216 [111111000000000002] => 213 [111111000000000010] => 207 ) [1] => Array ( [111111000000000008] => 231 [111111000000000007] => 228 [111111000000000006] => 225 [111111000000000005] => 222 [111111000000000001] => 210 ) [3] => Array ( [111111000000000013] => 243 [111111000000000012] => 240 ) ) [lizongji] => Array ( [111111000000000009] => 297 [111111000000000008] => 297 [111111000000000011] => 297 [111111000000000012] => 297 [111111000000000013] => 297 [111111000000000007] => 297 [111111000000000006] => 297 [111111000000000002] => 297 [111111000000000001] => 297 [111111000000000003] => 297 [111111000000000004] => 297 [111111000000000005] => 297 [111111000000000010] => 297 ) [lizongban] => Array ( [2] => Array ( [111111000000000009] => 297 [111111000000000011] => 297 [111111000000000004] => 297 [111111000000000003] => 297 [111111000000000002] => 297 [111111000000000010] => 297 ) [1] => Array ( [111111000000000008] => 297 [111111000000000007] => 297 [111111000000000006] => 297 [111111000000000005] => 297 [111111000000000001] => 297 ) [3] => Array ( [111111000000000013] => 297 [111111000000000012] => 297 ) ) [zongfenji] => Array ( [111111000000000013] => 764 [111111000000000012] => 761 [111111000000000011] => 758 [111111000000000009] => 755 [111111000000000008] => 752 [111111000000000007] => 749 [111111000000000006] => 746 [111111000000000005] => 743 [111111000000000004] => 740 [111111000000000003] => 737 [111111000000000002] => 734 [111111000000000001] => 731 [111111000000000010] => 728 ) [zongfenban] => Array ( [2] => Array ( [111111000000000011] => 758 [111111000000000009] => 755 [111111000000000004] => 740 [111111000000000003] => 737 [111111000000000002] => 734 [111111000000000010] => 728 ) [1] => Array ( [111111000000000008] => 752 [111111000000000007] => 749 [111111000000000006] => 746 [111111000000000005] => 743 [111111000000000001] => 731 ) [3] => Array ( [111111000000000013] => 764 [111111000000000012] => 761 ) ))</code>
回复内容：
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：mysql – PHP数据排序问题？
转载请注明原文链接：mysql – PHP数据排序问题？
