vboopathicse Posted September 8, 2011 Share Posted September 8, 2011 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. Quote Link to comment Share on other sites More sharing options...
nilansanjaya Posted September 8, 2011 Share Posted September 8, 2011 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.