列数与第1行的值计数不匹配，任何建议[关闭]

Question

I'm getting an error using PHP and MySQL for inserting a query from a form into a databse. The error is

Column count doesn't match value count at row 1

$sql = "INSERT INTO Jobs (
    JobSubject,
    JobCompany,
    JobSalary,
    JobLocation,
    JobDate,
    JobCat,
    JobPostBy
) VALUES (
    '" . mysql_real_escape_string($_POST['JobSubject']) . "',
    " . mysql_real_escape_string($_POST['JobCompany']) .",
    " . mysql_real_escape_string($_POST['JobSalary']) .",
    " . mysql_real_escape_string($_POST['JobLocation']) .",
    NOW(),
    " . mysql_real_escape_string($_POST['JobCat']) . ",
    " . $_SESSION['userId'] . "
)";

Answer 1

You are missing some single quotes.

Here's the correct syntax:

$sql = "
    INSERT INTO Jobs (
        JobSubject,
        JobCompany,
        JobSalary,
        JobLocation,
        JobDate,
        JobCat,
        JobPostBy
    )
    VALUES(
        '" . mysql_real_escape_string($_POST['JobSubject']) . "',
        '" . mysql_real_escape_string($_POST['JobCompany']) . "',
        '" . mysql_real_escape_string($_POST['JobSalary']) . "',
        '" . mysql_real_escape_string($_POST['JobLocation']) . "',
        NOW(),
        '" . mysql_real_escape_string($_POST['JobCat']) . "',
        '" . $_SESSION['userId'] . "'
    )
";