buscar valor de coluna de uma tabela
não estou a conseguir buscar o valor correcto de uma coluna numa determina linha
vai me buscar sempre a ultima linha
o que estou a fazer de errado
<table class="table table-striped table-bordered">
<thead>
<th style="visibility:collapse">ID </th>
<th>Nome </th>
<th>Descricao </th>
<th>Quantidade </th>
<th>Preco Sem Iva </th>
<th>Descontos </th>
<th>IVA </th>
<th>Valor do Desconto </th>
<th>Valor do IVA </th>
<th>Preço TOTAL </th>
<th>Ver</th>
</thead>
<tbody>
<?php foreach ($servicos->getservicosempresa($d)as $r): ?>
<tr>
<!--tr-->
<?php
if($r['quantidade']==0){
?>
<td style="visibility:collapse"><?php echo $r['id']; ?><input name="id" id="id" style="visibility:hidden;width: 5px" class="form-horizontal" value="<?php echo $r['id'];?>" type="text"></td>
<td style="background-color:#CC0000"><?php echo $r['nome']; ?>
</td>
<td style="background-color:#CC0000"><?php echo $r['descricao']; ?>
</td>
<td style="background-color:#CC0000"><?php echo $r['quantidade']; ?>
</td>
<td style="background-color:#CC0000"><?php echo $r['precosiva']; ?></td>
<td style="background-color:#CC0000"><?php echo $r['descontos']; ?></td>
<td style="background-color:#CC0000"><?php echo $r['iva']; ?>
</td>
<td style="background-color:#CC0000"><?php echo $r['valordesc']; ?>
</td>
<td style="background-color:#CC0000"><?php echo $r['valoriva']; ?>
</td>
<td style="background-color:#CC0000"><?php echo $r['precototal']; ?>
</td>
<td style="visibility:hidden"> <button type="submit" class="btn">
<span class="glyphicon glyphicon-pencil"></span> Selecionar
</button>
</td>
</tr>
<?php
} else if($r['quantidade']<=5 & $r['quantidade']>0){?>
<td style="visibility:collapse"><?php echo $r['id']; ?><input name="id" id="id" style="visibility:hidden;width: 5px" class="form-horizontal" value="<?php echo $r['id'];?>" type="text"></td>
<td style="background-color:#F5E79E"><?php echo $r['nome']; ?>
</td>
<td style="background-color:#F5E79E"><?php echo $r['descricao']; ?>
</td>
<td style="background-color:#F5E79E"><?php echo $r['quantidade']; ?>
</td>
<td style="background-color:#F5E79E"><?php echo $r['precosiva']; ?></td>
<td style="background-color:#F5E79E"><?php echo $r['descontos']; ?></td>
<td style="background-color:#F5E79E"><?php echo $r['iva']; ?>
</td>
<td style="background-color:#F5E79E"><?php echo $r['valordesc']; ?>
</td>
<td style="background-color:#F5E79E"><?php echo $r['valoriva']; ?>
</td>
<td style="background-color:#F5E79E"><?php echo $r['precototal']; ?>
</td>
<td> <button type="submit" class="btn">
<span class="glyphicon glyphicon-pencil"></span> Selecionar
</button>
</td>
</tr>
<?php
}
else {?>
<td style="visibility:collapse"><?php echo $r['id']; ?><input name="id" id="id" style="visibility:hidden;width: 5px" class="form-horizontal" value="<?php echo $r['id'];?>" type="text"></td>
<td ><?php echo $r['nome']; ?>
</td>
<td><?php echo $r['descricao']; ?>
</td>
<td><?php echo $r['quantidade']; ?>
</td>
<td><?php echo $r['precosiva']; ?></td>
<td><?php echo $r['descontos']; ?></td>
<td><?php echo $r['iva']; ?>
</td>
<td><?php echo $r['valordesc']; ?>
</td>
<td><?php echo $r['valoriva']; ?>
</td>
<td><?php echo $r['precototal']; ?>
</td>
<td> <button type="submit" class="btn">
<span class="glyphicon glyphicon-pencil"></span> Selecionar
</button>
</td>
<?php }
?>
</tr>
<?php endforeach; ?>
</tbody>
</table>Discussão (1)
Carregando comentários...