You're missing a curly bracket...
Code:
<?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";
$result = mysql_query($query)
while ($r = mysql_fetch_array($result)) {
extract($r);
$fincome = $extractors * 2000 ;
$sincome = $extractors * $advanced ;
$income = $fincome + $sincome ;
$query ="UPDATE founds SET balance = $income WHERE id = $id";
$result = mysql_query($query);
}
echo("Account Balance Updated");
?>