The number of MySQL columns does not match the number of values ​​in row 1

Question

I am trying to insert data into a MySQL table using PHP, but getting an error

The number of columns does not match the number of values ​​in row 1

mysql_query("INSERT INTO file (id, filename, extention, filelink, filesize, filepass) VALUES('{$random}', '{$filename}', '{$extension}', '{$filelink}', '{$filesize}' '{$filepass}') ") or die(mysql_error()); 

Answer 1

 mysql_query("INSERT INTO file (id, filename, extention, filelink, filesize, filepass) VALUES('{$random}', '{$filename}', '{$extension}', '{$filelink}', '{$filesize}' '{$filepass}') ") or die(mysql_error()); 

You must add the missing comma after {$ filesize}:

 mysql_query("INSERT INTO file (id, filename, extention, filelink, filesize, filepass) VALUES('{$random}', '{$filename}', '{$extension}', '{$filelink}', '{$filesize}', '{$filepass}') ") or die(mysql_error()); 

Answer 2

'{$filesize}' '{$filepass}' treated as a single value because you are missing a comma. Your request will look like this:

 INSERT INTO file (id, filename, extention, filelink, filesize, filepass) VALUES ( '{$random}', '{$filename}', '{$extension}', '{$filelink}', '{$filesize}' '{$filepass}') 

There. You have 6 columns and 5 values. The number of columns does not match the value, so MySQL displays an error message.