w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
Form submission Error: Column count doesn't match value count at row 1

This error is self explanatory - you are trying to set X columns by providing Y values, but the X must equal Y. In other works if you try to set 3 columns by providing 2 values, you will get that error. Check passed arguments and add missing one

If you are using MySQL then I suggest using different syntax, which is less error prone:

 INSERT INTO table SET column=value, column2=value2, ...;

BTW: you are asking for troubles not escaping your values. NEVER pass user provided content directly to your query - always escape using mysqli_real_escape_string() or similar methods. Or use PDO.





© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.