列数与第1行的值计数不匹配（列和值相等）

Question

I'm getting the error: Column count doesn't match value count at row 1

I think, normally this error occurs if the count of the columns and the values aren't equal, but in my code they are...(3).

This is my php code:

    $tempsongtitel = $_POST['songtitle'];
    $tempinterpret = $_POST['interpret'];
    $templink = $_POST['link'];

    $query = mysql_query("insert into tMusic (Songtitel, Interpret, Link) values ('$tempsongtitel, $tempinterpret, $templink')") or die(mysql_error());

Answer 1

You missed some quotes. Should be:

$query = mysql_query("insert into tMusic (Songtitel, Interpret, Link) values ('$tempsongtitel', '$tempinterpret', '$templink')") or die(mysql_error());

Otherwise, you were trying to insert all three POST values into the first field.

Moreover, the mysql_ extension has been deprecated and is on the way out and is highly discouraged, especially if you are creating new software.

AND I'll presume you are first sanitizing your data? You're not really taking user input and placing it directly into the database, are you? Even if you don't do any data validation, you should escape your data in the query... easiest and most foolproof way to do that is by using parameterized queries.