php query
Posted: Sat Mar 20, 2004 12:49 am
my result is this
testId studentId marks result title name
1 96 5 Passed Test Your IQ? Paul
1 96 6 Passed Test Your IQ? Paul
1 78 0 Failed Test Your IQ? Mark
1 96 1 Failed Test Your IQ? Paul
How can i change the RS to:
how many times each student appeared 4 each test
eg Paul takes Test Your IQ? 3 times mark 1 time
pls help
testId studentId marks result title name
1 96 5 Passed Test Your IQ? Paul
1 96 6 Passed Test Your IQ? Paul
1 78 0 Failed Test Your IQ? Mark
1 96 1 Failed Test Your IQ? Paul
How can i change the RS to:
how many times each student appeared 4 each test
eg Paul takes Test Your IQ? 3 times mark 1 time
pls help