错误列计数与第1行的值计数不匹配? [英] Error Column count doesn't match value count at row 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')";

这篇关于错误列计数与第1行的值计数不匹配?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！