Page 1 of 1

Please help with student's marks report

Posted: Thu Jun 14, 2012 3:54 pm
by hawkeye4u
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