字段列表中的未知列不存在 - Unknown column in field list that's not there

Unknown column in field list that's not there

本文关键字：不存在未知列表字段 | 更新日期: 2023-09-27

我有这个代码：

<?php
    include "../Header.php";
    $verify = mysql_query("SELECT * FROM Users WHERE Verified = 'YES'");
    while($row = mysql_fetch_array($verify))
    {
        mysql_query("INSERT INTO Inventory (UserID, ItemID, File, Type, code1, code2) VALUES ('" .
            $row['ID']."','96','40_c4cf313e76fc072a6be0a0959427246a.png','Accessory'," . sha1('40_c4cf313e76fc072a6be0a0959427246a').",'".sha1($row['ID'])."')") or die(mysql_error());
        echo $row['ID'];
    }

我收到此错误：

"字段列表"中的未知列"6c59be3b2b3c1ad356402243bf9a3eba66dee96d">

但是我的代码中没有关于该列的内容。

只需像这样将单引号括在您的 Sha 值周围：

mysql_query("INSERT INTO inventory 
        ( 
                    userid, 
                    itemid, 
                    FILE, 
                    type, 
                    code1, 
                    code2 
        ) 
        VALUES 
        ( 
                    '" . $row['id'] . "', 
                    '96', 
                    '40_c4cf313e76fc072a6be0a0959427246a.png', 
                    'Accessory', 
                    '" . sha1('40_c4cf313e76fc072a6be0a0959427246a') . "',   
                    '" . sha1($row['id']) . "' 
        )") or die(mysql_error());