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

本文介绍了错误列计数与第1行的值计数不匹配?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

哪里有错误..... 列数与第1行的值数不符

where is error..... Column count doesn't match value count at row 1

mysqli_select_db($conn, $data); $save = "INSERT INTO SONG_AS(ALBUM, CATEGORY, SUB_CATEGORY, SONG_NAME, ARTIST, ART_LINK, YEAR, GENRE, SONG_LINK, POST_ON, POST_BY, TOTAL_DOWNLOAD) VALUES('$albm', '$cat', '$scat', " . "'$sn', '$art', '$img', " . "'$y', '$g', " . "'$sl', '$time', '', '0')"; $success = mysqli_query($conn, $save) or die(mysqli_error($conn)); $page = "index.php"; $this->pageRedirect($page);

哪里有错误..... 列数与第1行的值数不符

where is error..... Column count doesn't match value count at row 1

推荐答案

尝试一下:

$save = "INSERT INTO SONG_AS(`ALBUM`, `CATEGORY`, `SUB_CATEGORY`, `SONG_NAME`, `ARTIST`, `ART_LINK`, `YEAR`, `GENRE`, `SONG_LINK`, `POST_ON`, `POST_BY`, `TOTAL_DOWNLOAD`) VALUES('".$albm."', '".$cat."', '".$scat."','".$sn."', '".$art."', '".$img."', '".$y."', '".$g."', '".$sl."', '".$time."', '', '0')";