http://www.aaa3.net/test-score-table/
php and mysql question specific student retrieve a range of all other students through the examination score.?
There mysql table name and fields called evidence as follows: the table: the fields of testing: three times a day, student, gid, Lesson, punctuation each test is connected to gid (group ID) of the test group by date .. Student online login for students. let's say 30 students took the same group test test is called A and each student has test scores and each time that each student can log into your account to see your own ranking of the 30 students. In student's account will be shown as an example: my rank: 30 / 5 30 represents the total number of students took the same test group that I can restore the number of student () Funtion where it connects specific ID test group for each test. and 5 is the range for which the student is fifth among the 30 students in accordance with the highest score. But how I can restore the 5? that is the range of student calculated the score of the students? Thank you for taking the time to read my question. I hope to get response
I would be: First establish a var number to be used in the results of its parent mysql – control your reference .. $ Dbname = 'your_dbname'; $ Student = '3 '; $ loop_num = 1; $ result = mysql ($ dbname, "SELECT student, the score test score order by DESC"); while ($ row = mysql_fetch_array ($ result)) ($ id_student $ row = ["Student"], $ results = $ row ["score"]; if ($ == $ id_student student) (echo $ loop_num break;) $ loop_num + +;)
Space Cadet Pinball – Score Max-Out (hidden test mode)
