Displaying html table help needed

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
thatsme
Forum Commoner
Posts: 87
Joined: Sat Apr 07, 2007 2:18 am

Displaying html table help needed

Post 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
User avatar
aceconcepts
DevNet Resident
Posts: 1424
Joined: Mon Feb 06, 2006 11:26 am
Location: London

Re: Displaying html table help needed

Post 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>';
}
 
Post Reply