display details from mysql using php
Posted: Thu Sep 08, 2011 2:05 am
hi,
I'm new in php/mysql. I'm stored student marks values in following format in mysql db table.
id student_code Tamil English Maths Science Social
1 1 100 75 78 88 95
2 2 85 90 88 80 100
But i want to search and display the specific student marks in following format.
id:1
student_code:1
Tamil:100
English:75
Maths:78
Science:88
Social:92
Total:?
Avg:?
please give correct code for this format.
I'm new in php/mysql. I'm stored student marks values in following format in mysql db table.
id student_code Tamil English Maths Science Social
1 1 100 75 78 88 95
2 2 85 90 88 80 100
But i want to search and display the specific student marks in following format.
id:1
student_code:1
Tamil:100
English:75
Maths:78
Science:88
Social:92
Total:?
Avg:?
please give correct code for this format.