blocks|key|5914978|text|基本上，sql告诉您，您在insert中引用了数据库中未定义的列。提供您的表结构或确保列名与您在数据库中定义的完全相同。HTH。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5914979|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Basically what sql is telling you that you are referencing a column in your insert that is not defined in the database. Provide your table structure or ensure that the column name is exactly as you defined in the db. HTH.

blocks|key|1041679|text|试试这个(用单个配额将每个变量包含在查询中)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1041680|mysql_query("INSERT+INTO+accounts(currentbalance,+balancein,+category,+notes)+
++++++++++VALUES+('$balancenew',+'$difference',+'$category',+'$notes')");++|code-block|syntax|javascript|1041681|最好使用mysqli或PDO来防止SQL注入攻击，目前可以使用mysql_real_escape_string()：|offset|length|1041682|$balancenew+=+mysql_real_escape_string($balancenew);|1041683|以及其他变量。|1041684|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/book.mysqli.php|1|http://php.net/manual/en/book.pdo.php^0|0|0|4|6|0|B|3|1|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@$I|11|J|12|1|13]|$I|14|J|15|1|16]]|A|$]]|$1|K|3|L|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|18|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]|W|$5|R|S|T|A|$U|X]]]]

try this (enclose each variable inside query with single quota):

<pre><code>mysql_query("INSERT INTO accounts(currentbalance, balancein, category, notes) 
 VALUES ('$balancenew', '$difference', '$category', '$notes')"); 
</code></pre>

Its better to use <a href="http://php.net/manual/en/book.mysqli.php" rel="noreferrer">mysqli</a> or <a href="http://php.net/manual/en/book.pdo.php" rel="noreferrer">PDO</a> to prevent from SQL injection attack, you could use mysql_real_escape_string() for now:

<pre><code>$balancenew = mysql_real_escape_string($balancenew);
</code></pre>

and for other variables.

blocks|key|5915003|text|这是因为您的INSERT查询中存在语法错误。字符串和日期值将传递给SQL单引号，而不是双引号。.或字符串连接字符也不是必需的。所以根据你提供的数据，它可能是|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|5915004|$query+=+mysql_query("INSERT+INTO+accounts(currentbalance,+balancein,+category,+notes)+
++++++++++++++++++++++VALUES+($balancenew,+$difference,+'$category',+'$notes')");++|code-block|syntax|javascript|5915005|entityMap^0|17|3|1B|1|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

Thats because you have syntax error in your INSERT query. String and Date values are to passed into single quotes and not double quotes in sql. the . or the String concatenation character is also not required. So based on the data you provided it might be

<pre><code>$query = mysql_query("INSERT INTO accounts(currentbalance, balancein, category, notes) 
 VALUES ($balancenew, $difference, '$category', '$notes')"); 
</code></pre>

blocks|key|5915015|text|我想您可能漏掉了用$notes和$category括起来的单个反逗号。把它们封装起来，你的问题就解决了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5915016|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You have missed single inverted commas enclosing $notes and $category I guess. Enclose them in ' and your problem should be solved.

i keep getting the following error from this simple mysql statement and i cant see why. im sure its something obvious.

<pre><code>require_once("connect.php");

$query = mysql_query("SELECT * FROM accounts ORDER BY id DESC LIMIT 1");
$row = mysql_fetch_assoc($query);

$balanceold = $row['balance'];
$difference = $_POST['predec'].".".$_POST['dec'];

$category = $_POST['category'];
$notes = $_POST['notes'];

if(isset($_POST['in'])){
$balancenew = $balanceold + $difference;
$query = mysql_query("INSERT INTO accounts(currentbalance, balancein, category, notes) VALUES (".$balancenew.", ".$difference.", ".$category.", ".$notes.")"); 
if($query){
header("Location: budget.php"); 
}
else{
die(mysql_error());
}
}
</code></pre>

gives error:
 Unknown column 'payday' in 'field list'

here is my form code:

<pre><code>&lt;form action=process.php method=post&gt;

&amp;pound;
&lt;input type=text name=predec size=7&gt;
. 
&lt;input type=text name=dec size=4 value=00&gt;
&lt;br /&gt;
&lt;select name=category&gt;
&lt;option value=payday&gt;Payday&lt;/option&gt;
&lt;/select&gt;
&lt;input type=text name=notes size=20&gt;
&lt;input type=submit name=in value=Deposit&gt;
&lt;input type=submit name=out value=Withdraw&gt;
&lt;/form&gt; 
</code></pre>

database table"accounts" contains the following fields:

id, int primary A_I

balancein, decimal 10,2

balanceout, decimal 10,2

current balance, decimal 10,2

category, varchar 50

notes, varchar 255

date, timestamp

...in that order

MYSQL - INSERT error, unknown column in field list

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我一直从这个简单的mysql语句中得到以下错误，我不明白为什么。我敢肯定这是显而易见的事情。require_once("connect.php");$query = mysql_query("SELECT * FROM accounts ORDER BY id DESC LIMIT 1");$row = mysql_f...

问MYSQL -插入错误，字段列表中有未知列
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MYSQL -插入错误，字段列表中有未知列EN