I am trying for the past few days in various ways to solve the below problem. Please give me a solution.
Db tables,
member_table
test_results
member_table structure,
member_id (pk) auto inc
member_fname
member_lname
member_test_taken_flag
test_results structure,
test_results_id(pk) auto inc
member_id(fk)
test_id
test_score
I have to display the above data in the format,
Code: Select all
<table border='1'><tr> <td>Members</td> <td>Member1</td> <td>Member2</td> <td>Member3</td> <td>Member4</td> <td>Membern</td></tr><tr> <td>Tests</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td></tr><tr> <td>test1</td> <td>member1score</td> <td>member2score</td> <td>member3score</td> <td>member4score</td> <td>membernscore</td></tr> <tr> <td>test2</td> <td>member1score</td> <td>member2score</td> <td>member3score</td> <td>member4score</td> <td>membernscore</td></tr> <tr> <td>test3</td> <td>member1score</td> <td>member2score</td> <td>member3score</td> <td>Not taken</td> <td>membernscore</td></tr> <tr> <td>test4</td> <td>member1score</td> <td>Not taken</td> <td>member3score</td> <td>member4score</td> <td>membernscore</td></tr> <tr> <td>testn</td> <td>Not taken</td> <td>member2score</td> <td>member3score</td> <td>member4score</td> <td>membernscore</td></tr></table>Thanks