ik ben bezig met een factuur script heb alleen nu een probleem met het optellen van de bedragen in de orders
kan iemand hier iets mee
<table cellspacing="1" class="tblBaseTblData" id="myScrollTable" width="1000">
<thead>
<tr NOWRAP>
<th> Factuur Nr</th>
<th> Bedrag Exc BTW</th>
<th> BTW Bedrag</th>
<th> Totaal Inc BTW</th>
<th> Voldaan</th>
<th> Factuur</th>
</tr>
</thead>
<tbody NOWRAP>
<?php
$order = "SELECT * FROM HWS_Orders WHERE fact != '0' GROUP BY fact ORDER BY fact DESC ";
$order = mysql_query($order);
$num = mysql_num_rows($order);
while ($order1 = mysql_fetch_array($order)){
$newstr7rest = substr("$order1[zendingsnr]", 0, 6);
$order2 = "SELECT * FROM HWS_Orders WHERE fact = '$order1[fact]'";
$order2 = mysql_query($order2);
$num2 = mysql_num_rows($order2);
while ($order3 = mysql_fetch_array($order2)){
$bedrag1[] = $order3[km] * $order3[kmtarief];
}
for ($i = 0; $i <= $num2; $i++){
$bedrag2 = $bedrag2 + $bedrag1[$i];
}
?>
<tr class="oddRow">
<td> <a href=# rel="balloon<?php echo "$order1[fact]"; ?>"><?php echo "$newstr7rest.$order1[fact]"; ?></a></td>
<td> <?php echo "$bedrag2"; ?></td>
<td> <?php echo "$btw"; ?></td>
<td> <?php echo "$totaal"; ?></td>
<td> <?php echo "$order1[voldaan]"; ?></td>
<td> <a href=http://www.hws-koeriers.nl/hws/fpdf/fact3.php?fact=<?php echo "$order1[fact]"; ?>&userid=<?php echo "$order1[userid]"; ?> target=_blank>Print</a></td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
</tfoot>
</table>
<script type="text/javascript">
var t = new ScrollableTable(document.getElementById('myScrollTable'), 32);
</script>
