just tell me if i dont make any sense?!
<?php
echo'<center><table border="1"><tr><td>';
echo'
<center>Geld op bank </br>
'.$row['bank'];
echo'<center><tr><td><form action="" method="post">
<center>Opnemen bedrag </br>
<input type="text" name="geld"></br>
<input type="submit" value="Submit" /></form><tr>';
$con = mysql_connect("x","coendamiaan","x");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("coendamiaan", $con);
if(($_POST['geld'])){
$sql2="DELETE FROM users WHERE test (bank)";
$sql3="DELETE FROM users WHERE test (money)";
$sql="INSERT INTO users WHERE test (bank, money)
VALUES ('$_POST[bankgeld]','$_POST[geld]')";
}
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "gestort.";
mysql_close($con)
?>
<?php
mysql_connect("x", "x", "x") or die(mysql_error());
mysql_select_db("coendamiaan") or die(mysql_error());
$query = "SELECT * FROM users";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result) or die(mysql_error());
echo'<center><table border="1"><tr><td>';
echo'
<center>Geld op bank </br>
'.$row['bank'];
?>