@blanche ik ben de slechtste titel verzinner ooit vraag maar aan santhe lol :P


oke mijn probleem is als volgt

Link:
http://www.dontsurfhere.com/game/test.php


Dit word niet uitgerekend het bedrag komt op 0 te staan steeds

$af =$bank - $comp * $price; 




<?php
$query = "SELECT * FROM users";

$result = mysql_query($query) or die(mysql_error());

$row = mysql_fetch_array($result) or die(mysql_error());


$query2 = "SELECT * FROM stock";

$result2 = mysql_query($query2) or die(mysql_error());

$row2 = mysql_fetch_array($result2) or die(mysql_error());


$comp = $_POST['buy'];
$af =$bank - $comp * $price;
$bank = $row['bank'];
$shares = $row2['shares'] - $_POST['buy'];
$preshares = $row2['shares'];
$price = $row2['price'];


if(($_POST['buy'])){

$result = mysql_query("UPDATE users SET bank='$af' WHERE bank='$bank'")
or die(mysql_error());


$result2 = mysql_query("UPDATE stock SET shares='$shares' WHERE shares='$preshares'")
or die(mysql_error());

}



echo'
<table><td align="center" width="400"><center>
<table border="1" cellspacing="0" cellpadding="2" bordercolor="black" width="100%" "> ';



echo '<tr><td class="header" align=center colspan=2><font color="#000000">Available money banked</font></td></tr><tr> ';

echo '<td bgcolor="#FFFFFF"><font color="#000000">Money</font></td><td bgcolor="#FFFFFF">';

echo '<font color="#000000"></font>$'.$row['bank'];

echo '</td> </tr><tr>';


echo '

<table border="1" align="center" width="400">
<form method="post" action="" name="f">
<td>Company</td>
<td>Shares</td>
<td>Price</td>
<td>Order</td>
</tr>';
echo '<td>'.$row2['company'];

echo'</td><td>'.$row2['shares'];

echo'</td><td>$'.$row2['price'];

echo' <td><input name="buy" size="2" maxlength="5" type="text" /><br />
</td>
</tr>
<tr>
<td>Totaal</td>
<td></td>
<td></td>
<td><input name="SUBMIT" value="Order" type="submit" /> </form></td>
</tr>';

echo '</table></tr>';



?>



Zucht
Je definieert $bank en $price pas nĂ¡ de berekening. Dan krijg je dus:

$af = null - $comp * null;

Reageren