I am trying to display data from data base. I want to make it grouped. Here is the template
I made the code like this :
<?php
$queg=pg_query("SELECT agentgroup.leadername,agentgroup.reviewername, agentgroup.supervisorname, agent.onlinename from agentgroup left join agent on agentgroup.agentid=agent.agentid order by agentgroup.leadername");
echo "<td class=\"form1\" align=\"center\" > Number </td>";
echo "<td class=\"form1\" align=\"center\" > Agent Group </td>";
echo "<td class=\"form1\" align=\"center\" > Coach </td>";
echo "<td class=\"form1\" align=\"center\" > Supervisor </td>";
echo "<td class=\"form1\" align=\"center\" > Agent Online Name </td>";
echo "<td class=\"form1\" align=\"center\" ></td>";
$gcount=1;
while($grow=pg_fetch_array($queg)){
echo "<tr>";
echo "<td class=\"forma\" rowspan=\"8\" align=\"center\"> ".$gcount++."</td>";
echo "<td class=\"forma\" rowspan=\"8\" align=\"left\"style=\"padding-left:10%;\"> ".$grow['leadername']." </td>";
echo "<td class=\"forma\" rowspan=\"8\" align=\"left\"style=\"padding-left:10%;\"> ".$grow['reviewername']." </td>";
echo "<td class=\"forma\" rowspan=\"8\" align=\"left\"style=\"padding-left:10%;\"> ".$grow['supervisorname']." </td>";
echo "<td class=\"forma\" align=\"left\"style=\"padding-left:10%;\"> ".$grow['onlinename']." </td>";
echo "<td class=\"forma\" rowspan=\"4"align=\"center\"><a href=\"#\" >edit</a></td>
</tr>";}
?>
But I got chaos.this is the current output
Any help to display those data? Thank you :D