Page 1 of 1

Displaying html table help needed

Posted: Sat Apr 05, 2008 12:56 am
by thatsme
Hi,

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>&nbsp;</td>  <td>&nbsp;</td>  <td>&nbsp;</td>  <td>&nbsp;</td>  <td>&nbsp;</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

Re: Displaying html table help needed

Posted: Sat Apr 05, 2008 9:09 am
by aceconcepts
Where your data is going to be displayed you need to run a loop:

Code: Select all

 
//connect to database
//query database
 
while($row=mysql_fetch_array($query))
{
   echo'<tr><td>data...</td></tr>';
}