display Column details from mysql using php

[vboopathicse]

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.

 

 

[nilansanjaya]

query the database and get the details.

 

then,

 

while( $row = mysql_fetch_array($results) ){ 

echo 'id: '.$row['id'].'<br />';

echo 'id: '.$row['tamil'].'<br />';

echo 'id: '.$row['english'].'<br />';

echo 'id: '.$row['maths'].'<br />';

}

 

 

you can do the html formatting part as you want. its just a example