How to insert records from multiple rows and columns

Vote count:

0

Pls guys I'm having a difficult time figuring this out. I have a page which allows record of students to be entered based on the number of students in that class. I can't just create a form with 30 fields(test1,test2...) for a column and another for the next column. So I created a loop. But the results isn't pleasant...instead of getting the. records fitting into the respective rows and columns, it goes like this..

---

Id|Name|test1|test2|exam|total| 1 | a. |15 |0 |0 |0

2 | a. |0 |20 |0 |0

3 | a. |0 |0 |50 |0

4 | a. |0 |0 |0 |85

...but I was expecting this

---

Id|Name|test1|test2|exam|total| 1 | a |15 |20 |50 |85

So on ... How can I achieve this please

asked 14 secs ago

IBK

1

How to insert records from multiple rows and columns