Hello, I have a project that I've been working for a while but havent been able to do it. I have to make a table that goes first in the header the group leader, then in the second row it's going to appear the different team leaders that are bellow that group leader, and then bellow every team leader, the members that are bellow him.
I have tried different ways to make the sql tables but I dont know if im doing it right, I'll paste an html code to show kinda what I am looking for. I will really appreciate if someone can help.
<table border="1">
<tr>
<th colspan="4" scope="col">Group Leader 1</th>
</tr>
<tr>
<td>Team Leader 1</td>
<td>Team Leader 2</td>
<td>Team Leader 3</td>
<td>Team Leader 4</td>
</tr>
<tr>
<td>Member 1</td>
<td>Member 5</td>
<td>Member 8</td>
<td>Member 12</td>
</tr>
<tr>
<td>Member 2</td>
<td>Member 6</td>
<td>Member 9</td>
<td>Member 13</td>
</tr>
<tr>
<td>Member 3</td>
<td>Member 7</td>
<td>Member 10</td>
<td> </td>
</tr>
<tr>
<td>Member 4</td>
<td> </td>
<td>Member 11</td>
<td> </td>
</tr>
</table>
<table border="1">
<tr>
<th colspan="3" scope="col">Group Leader 2</th>
</tr>
<tr>
<td>Team Leader 5</td>
<td>Team Leader 6</td>
<td>Team Leader 7</td>
</tr>
<tr>
<td>Member 14</td>
<td>Member 18</td>
<td>Member 21</td>
</tr>
<tr>
<td>Member 15</td>
<td>Member 19</td>
<td>Member 22</td>
</tr>
<tr>
<td>Member 16</td>
<td>Member 20</td>
<td>Member 23</td>
</tr>
<tr>
<td>Member 17</td>
<td> </td>
<td>Member 24</td>
</tr>
</table>
