I have a table called subject_scores
which has the following fields:
candidateNumber, paperCode, paperNumber, question1, question2, ... , question20
The issue is displaying it in the view (CodeIgniter), here's my code:
<table class="table table-striped table-condensed" id="example">
<thead>
<tr>
<th>Candidate Number</th>
<th>Paper Code</th>
<th>Paper Number</th>
<?php for ($i = 1; $i <= 20; $i++) : ?>
<th><?php echo 'Q'.$i; ?></th>
<?php endfor; ?>
<th>Total</th>
</tr>
</thead>
<tbody>
<?php if (isset($scores)) : foreach ($scores as $row) : ?>
<tr>
<td><?php echo $row->candidateNumber; ?></td>
<td><?php echo $row->paperCode; ?></td>
<td><?php echo $row->paperNumber; ?></td>
<td><?php echo $row->status; ?></td>
<?php for ($i = 1; $i <= 20; $i++) : ?>
<?php if ($row->question.$i == NULL) : ?>
<td><span class="red">NA</span></td>
<?php else : ?>
<td><?php echo $row->question.$i; ?></td>
<?php endif; ?>
<?php endfor; ?>
</tr>
<?php endforeach; endif; ?>
</tbody>
</table>
From the above code you'll notice I've used something like this $row->question.$i
to combine the array value with the increment to create fields from question1 to question20.
How do I do this correctly either in PHP or CodeIgniter?