Hide repeat region duplicate records...
Dear people,
In a mysqli query use two fields: category and movie
What I wish to get is a list with movies per category
The following returns what I need but can't hide the duplicated categories
Could you please help?
Thank's
<?php
$wa_startindex = 0;
while(!$Recordset1->atEnd()) {
$wa_startindex = $Recordset1->Index;
?>
<table width="100%">
<tbody>
<tr>
<td><?php echo($Recordset1->getColumnVal("category")); ?></td>
</tr>
</tbody>
</table>
<tr>
<td width="100%"></td>
</tr>
<table width="100%">
<tbody>
<tr>
<td width="100%"><?php echo($Recordset1->getColumnVal("movie")); ?></td>
</tr>
</tbody>
</table>
<?php
$Recordset1->moveNext();
}
$Recordset1->moveFirst(); //return RS to first record
unset($wa_startindex);
unset($wa_repeatcount);
?>