Query Manipulation after getting a result set
Posted: Fri Mar 19, 2004 10:25 pm
my query result is this
#######################
TestName | Count | Result
PHP 1 Passed
PHP 1 Failed
Test Your IQ? 2 Passed
Test Your IQ? 5 Failed
######################
i want to manipulate the result so that i can show it like this
############################
TestName Count PassCount FailCount
PHP 2 1 1
Test Your IQ? 7 2 5
#############################
How can i do this
Pls Help
Thanx in Advance
[/b][/php_man]
#######################
TestName | Count | Result
PHP 1 Passed
PHP 1 Failed
Test Your IQ? 2 Passed
Test Your IQ? 5 Failed
######################
i want to manipulate the result so that i can show it like this
############################
TestName Count PassCount FailCount
PHP 2 1 1
Test Your IQ? 7 2 5
#############################
How can i do this
Pls Help
Thanx in Advance
[/b][/php_man]