timber16

im having a problem regarding on how to subtract the amount and the current balance of a creditcard dummy . i really need it on my project. please help me. <?php /* ELOAD_VIEW.PHP Displays all data from 'players' table */ // connect to the database include('connect-db.php'); // get results from database $result = mysql_query("SELECT * FROM eload") or die(mysql_error()); // display data in table echo "<p><b>View All</b> | <a href=eload_list_view.php?page=1'>View Paginated</a></p>"; echo "<table border='1' cellpadding='5'>"; echo "<tr> <th>ID</th> <th>Gamecard Purchase</th> <th>Amount</th> <th>Quantity</th> <th>Transaction</th> <th></th> <th></th></tr>"; // loop through results of database query, displaying them in the table while($row = mysql_fetch_array( $result )) { echo "<tr>"; echo '<td>' . $row['id'] . '</td>'; echo '<td>' . $row['gamecard'] . '</td>'; echo '<td>' . $row['amount'] . '</td>'; echo '<td>' . $row['quantity'] . '</td>'; echo '<td>' . $row['transaction'] . '</td>'; echo '<td><a href="eload_edit.php?id=' . $row['id'] . '">Change</a></td>'; echo '<td><a href="eload_delete.php?id=' . $row['id'] . '">Delete Transaction</a></td>'; echo "</tr>"; } $result = mysql_query("SELECT * FROM eload") or die(mysql_error()); echo "<table border='1' cellpadding='10'>"; echo "<tr> <th>ID</th> <th>amount</th> <th>Balance</th> <th>Quantity</th> <th>Current Balance</th></tr>"; // loop through results of database query, displaying them in the table while($row = mysql_fetch_array( $result )) { echo "<tr>"; echo '<td>' . $row['id'] . '</td>'; echo '<td>' . $row['amount'] . '</td>'; echo '<td>' . $row['balance'] . '</td>'; echo '<td>' . $row['sum_total = $quantity * $amount - $balance'] . '</td>'; echo "</tr>"; echo ($sum_total); } // close table> echo "</table>"; echo "<p><a href='eload.php?page=1'>Another Transaction?Click Here</a></p>"; ?> :( :( :(