php未知错误,php – 未知列,错误

有人可以帮助我解决这个错误,我找不到问题.

我知道我的代码是废话,我应该使用PDO.

我正在尝试为我的游戏制作交易脚本,这是用户接受或拒绝交易的页面,我还没有尝试添加拒绝功能.截至目前我收到此错误.

Unknown column ‘nick’ in ‘field list’

if ($_POST['A'] == '1' ) {

$token= mysql_real_escape_string($_POST['token']);

$tokenn = strip_tags($token);

$sql234 = "SELECT * FROM trade WHERE trade_to='".$_SESSION['username']."'";

$result2 = mysql_query("SELECT * FROM trade WHERE trade_to='".$_SESSION['username']."'");

while($row2 = mysql_fetch_array($result2)){

$sql23 = "SELECT * FROM users WHERE username='".$_SESSION['username']."')";

$result = mysql_query("SELECT * FROM users WHERE username='".$_SESSION['username']."'");

while($row = mysql_fetch_array($result)){

if (isset($_POST['slot1'])) {

echo "

You have accepted the trade.

" ;

mysql_query("UPDATE user_pokemon SET belongsto=".$row2['trade_to']." WHERE id='".$row2['trade_pokeid']."'")

or die(mysql_error());

mysql_query("UPDATE user_pokemon SET belongsto=".$row2['trade_from']." WHERE id='".$row2['trade_mypokeid']."'")

or die(mysql_error());

mysql_query("DELETE FROM trade WHERE trade_id=".$row2['trade_id']."")

or die(mysql_error());

} else {

}

}

}

}

?>

$result = mysql_query("SELECT * FROM trade WHERE trade_to='".$_SESSION['username']."'");

while($row = mysql_fetch_array($result))

{

$idd= mysql_real_escape_string($row['trade_id']);

$iddd = strip_tags($idd);

?>

Buy

echo $row ['trade_id'];

}

?>