Please help with student's marks report
Posted: Thu Jun 14, 2012 3:54 pm
Hello every body
Please help me to write this code
i want to display table like this
[img]http://imageshack.us/photo/my-images/443/reportw.jpg/
[/img]
Generated from three database tables depends on student ID
1- Exams table
[img]http://imageshack.us/photo/my-images/59/examsq.jpg/
[/img]
2-Subjects
[img]http://imageshack.us/photo/my-images/823/subjects.jpg/
[/img]
3-Stu_Marks
[img]http://imageshack.us/photo/my-images/580/stugrades.jpg/
[/img]
So i want to display this table without any fixed value of exams or subjects
And is this the best way to insert the students marks?? coz by this way if i have 5000 student and 10 subjects and 12 exam in year .. i will have mor than 500.000 record in table Stu_Marks
sorry for my english language
Please help me to write this code
i want to display table like this
[img]http://imageshack.us/photo/my-images/443/reportw.jpg/
[/img]
Generated from three database tables depends on student ID
1- Exams table
[img]http://imageshack.us/photo/my-images/59/examsq.jpg/
[/img]
2-Subjects
[img]http://imageshack.us/photo/my-images/823/subjects.jpg/
[/img]
3-Stu_Marks
[img]http://imageshack.us/photo/my-images/580/stugrades.jpg/
[/img]
So i want to display this table without any fixed value of exams or subjects
And is this the best way to insert the students marks?? coz by this way if i have 5000 student and 10 subjects and 12 exam in year .. i will have mor than 500.000 record in table Stu_Marks
sorry for my english language