View Single Post
Old 11-28-2002, 02:39 PM   PM User | #7
Wichetael
New Coder

 
Join Date: Nov 2002
Location: Netherlands
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Wichetael has a little shameless behaviour in the past
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");

?>
Wichetael is offline   Reply With Quote