[sir pannels]

...some info in a table doesnt work..
hmm you see the $id is from the url the rest is either in the script or the db.... its meant to get the current balance... and work out how much it should go up and then updat eit to the new baance.. it errors.. any one see why?

<?php
$dbc = mysql_connect('localhost', '', '') or die("Couldn't connect to database"); 
 mysql_select_db('GAME') or die("Couldn't select database"); 

$query ="SELECT * FROM founds WHERE id=$id";
$query ="UPDATE founds SET balance = $income WHERE id =$id";

$result = mysql_query($query) or die("There is an error with you account, please contact support and inform them of this"); 
 while ($r = mysql_fetch_array($result)) { 
 extract($r);

        $fincome = $extractors * 2000 ;
        $sincome = $extractors * $advanced ;
        $income = $fincome + $sincome ;

echo("Account Balance Updated");

?>

thanks a lot