w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
Syntax issue UPDATE works but not INSERT

The datatype for the field 'category_of_taxom' is most likely set to varchar, meaning it should have quotes around the value when using INSERT. So you can either:

1) Change the datatype of category_of_taxom to integer in your database

2) Include quotes around the value in your INSERT statement:

('1','1','1','$number_of_taxom1',$sheet_id)

Related documentation: mysql - quote numbers or not?





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