'where子句'中的未知列'type'(Unknown column 'type' in 'where clause')

 干草每个人我都有一些问题，只是想知道你们中的任何一位能否帮助我。 
 
 当谈到MySQL和PHP时，我有点小气，但问题在于，当我尝试向我的数据库中添加注释时，我是geetin错误，这是我的公共功能代码 
 
    public function addComment($movieid, $comment, $user_id)
{
    $comment = stripslashes(strip_tags($comment));
    $comment = mysql_real_escape_string($comment);
    $movieid = mysql_real_escape_string($movieid);
    $user_id = mysql_real_escape_string($user_id);
    if (!($e = mysql_query("SELECT * FROM comments WHERE target_id='{$movieid}' AND user_id='{$user_id}' AND comment='{$comment}' AND type=2"))) {
        exit(mysql_error());
    }
    if (mysql_num_rows($e) == 0) {
        if (!($e = mysql_query("INSERT INTO comments(target_id,user_id,comment,date_added,type) VALUES('{$movieid}','{$user_id}','{$comment}',NOW(),2)"))) {
            exit(mysql_error());
        }
    }
}
 
 这里是我的MySQL评论表结构 
 
 1  id                int(11)                       No  None    AUTO_INCREMENT   
 2  movieid           int(11)                       No  None         
 3  user_id           int(11)                       No  None         
 4  target_id         int(11)                       No  None         
 5  comment           text       utf8_general_ci    No  None         
 6  date_added        datetime                      No  None    
 
 但是当我尝试添加评论时出现此错误 
 
Unknown column 'type' in 'where clause'
 
 所以有人可以帮助我 
 
 谢谢 

Hay Everyone i've got a bit of a problem and just wondering if any of you can help me out.
 
i'm a bit of a noob when it comes to MySQL and PHP but the problem is i'm geetin a error when i try to add a comment into my Database here is my public function code
 
    public function addComment($movieid, $comment, $user_id)
{
    $comment = stripslashes(strip_tags($comment));
    $comment = mysql_real_escape_string($comment);
    $movieid = mysql_real_escape_string($movieid);
    $user_id = mysql_real_escape_string($user_id);
    if (!($e = mysql_query("SELECT * FROM comments WHERE target_id='{$movieid}' AND user_id='{$user_id}' AND comment='{$comment}' AND type=2"))) {
        exit(mysql_error());
    }
    if (mysql_num_rows($e) == 0) {
        if (!($e = mysql_query("INSERT INTO comments(target_id,user_id,comment,date_added,type) VALUES('{$movieid}','{$user_id}','{$comment}',NOW(),2)"))) {
            exit(mysql_error());
        }
    }
}
 
and here is my MySQL comment table Structures 
 
 1  id                int(11)                       No  None    AUTO_INCREMENT   
 2  movieid           int(11)                       No  None         
 3  user_id           int(11)                       No  None         
 4  target_id         int(11)                       No  None         
 5  comment           text       utf8_general_ci    No  None         
 6  date_added        datetime                      No  None    
 
but i get this error when i try to add a comment 
 
Unknown column 'type' in 'where clause'
 
so could someone help help me 
 
thanks 

原文：https://stackoverflow.com/questions/17876330