CREATE TABLE `auc` (     
`id` INT( 11 ) NOT NULL ,     
`guid` VARCHAR( 255 ) NOT NULL ,     
`bid` VARCHAR( 255 ) NOT NULL ,     
`buyout` VARCHAR( 255 ) NOT NULL ,     
`lastbid` VARCHAR( 255 ) NOT NULL ,     
`owner` VARCHAR( 255 ) NOT NULL ,     
PRIMARY KEY ( `id` )      
) ENGINE = MYISAM;

$query = mysql_query("SELECT * FROM `auc` ORDER BY `id` DESC");
echo "<table><tr><td>Имя персонажа</td><td>Текущая стоимость</td><td>Выкуп</td></tr>";
while($lot = mysql_fetch_array($query)){
$get_name = mysql_query("SELECT `name` FROM `characters` WHERE `guid`='".$lot['guid']."'");
$name = mysql_fetch_array($get_name);
echo "<tr><td>".$name['name']."</td><td>".$lot['bid']."</td><td>".$lot['buyout']."</td></tr>";
}
echo "</table>";

UPDATE TABLE `auc` (     
`balance` VARCHAR( 255 ) NOT NULL ,     
PRIMARY KEY ( `id` )      
) ENGINE = MYISAM;

Code
$you = "ваш аккаунт" В ЛК создайте переменную или кук     
$query = mysql_query("SELECT * FROM `auc` ORDER BY `id` DESC");     
echo "<table><tr><td>Имя персонажа</td><td>Текущая ставка</td><td>Выкуп</td></tr>";     
      while($lot = mysql_fetch_array($query)){     
        $get_name = mysql_query("SELECT `name` FROM `characters` WHERE `guid`='".$lot['guid']."'");     
        $name = mysql_fetch_array($get_name);     
        echo "<tr><td>".$name['name']."</td><td>".$lot['bid']."     
<form action=/ method=post>     
<input type=hidden name=act value=bid>     
<input type=hidden name=tar value=".$lot['guid'].">     
<input type=hidden name=cost value=".$lot['bid'].">     
<input type=hidden name=buyer value=".$you.">     
<input type=submit value=Предложить>     
</form>     
</td><td>".$lot['buyout']."     
<form action=/ method=post>     
<input type=hidden name=act value=buyout>     
<input type=hidden name=tar value=".$lot['guid'].">     
<input type=hidden name=cost value=".$lot['buyout'].">     
<input type=hidden name=buyer value=".$you.">     
<input type=submit value=Выкупить>     
</form>     
</td></tr>";     
      }     
echo "</table>";     
         
     

if(@$_POST['act'] == "bid"){     
$get_balance = mysql_query("SELECT `balance` FROM `balance` WHERE `acc_id`='".$_POST['buyer']."'");     
$balance = mysql_fetch_array($get_balance);     
if($balance['balance'] >= $_POST['cost']){     
}else{     
echo "Не достаточно бонусов, пополните счет";     
}     
}elseif(@$_POST['act'] == "buyout"){     
$get_balance = mysql_query("SELECT `balance` FROM `balance` WHERE `acc_id`='".$_POST['buyer']."'");     
$balance = mysql_fetch_array($get_balance);     
if($balance['balance'] >= $_POST['cost']){     
$query = mysql_query("UPDATE `characters` SET `acc_id`='$you' WHERE `guid`='"$_POST['guid']"');     
if($query)     
echo "Персонаж выкуплен!";     
}else{     
echo "Не достаточно бонусов, пополните счет!";     
}