Mysqli错误：列数与第1行的值计数不匹配-MysqliError:Columncountdoesn'tmatchvaluecountatrow1

Below is the mysqli query that is being performed, anyone know what I get such error:

下面是正在执行的mysqli查询,任何人都知道我得到了这样的错误:

$sql = mysqli_query($db, "INSERT INTO `tbl_bugzilla` 
    (`id`, `by`, `title`, `content`, `date`, `application`,`priority`, `assigned`, `status`) 
    VALUES (NULL, '".$_SESSION['exp_user']['username']."', '"
        .$_SESSION['exp_user']['username']."', '".$title."', '".$content."','"
        .$dt."', '".$_POST['app']."', '".$_POST['priority']."', 'Unassigned', 'Unconfirmed')");

Error: Column count doesn't match value count at row 1

错误:列计数与第1行的值计数不匹配

More importantly, could you explain the error so I don't make the same mistake again?

更重要的是,你能解释一下这个错误,所以我不会再犯同样的错误吗?

Thanks

1 个解决方案