Hello, I need help to create dynamic table using data from database
like this
<table border="1">
<tr>
<td>Coutry</td>
<td>Position</td>
<td>Name</td>
</tr>
<tr>
<td rowspan="9">Usa</td>
<td rowspan="2">North Countries</td>
<td>Montana</td>
</tr>
<tr>
<td>Minesota</td>
</tr>
<tr>
<td rowspan="3">Middle Countries</td>
<td>Colorado</td>
</tr>
<tr>
<td>Cansas</td>
</tr>
<tr>
<td>Colorado</td>
</tr>
<td rowspan="4">South Countries</td>
<td>Arizona</td>
</tr>
<tr>
<td>Texas</td>
</tr>
<tr>
<td>Alabama</td>
</tr>
<tr>
<td>Florida</td>
</tr>
<tr>
<td rowspan="4">Canada</td>
<td rowspan="2">NorthCountry</td>
<td>Nunavut</td>
</tr>
<tr>
<td>Yucon</td>
</tr>
<tr>
<td rowspan="2">South Countries</td>
<td>Ontario</td>
</tr>
<tr>
<td>Alberta</td>
</tr>
</table>
I’m using
foreach ($data as $i=> $countries)
{
foreach($countries=>$k=>$v)
{
//get names from table
${$k}=$v;
}
echo ' <tr>
<td rowspan="4">$country</td>
<td rowspan="2">$position</td>
<td>$name</td>
</tr>"
}
problem is i don’t know how to use this rowspan , i can count but how to use for other <tr></tr>
to creati table, in my database i have all country not few like in example