Hi all,

I am trying to add the path of my file into one of the columns in MySQLDB Table. The column, FilePath, data type is Text.

An example of the file path to be added would be: C:/Temp/abc.jpg. I am using:

PHP Code:

mysql_query("Insert Into table(FilePath,booleanValue)Values('C:/Temp/abc.jpg','0');"); 


The error i keep encountering is:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1',,,,'C:/Temp/abc.jpg' at line 2

Any help is appreciated!

It looks like it is the boolean value that could be causing it? The booleanValue data type is boolean. Am i adding it correctly via the insert statement?

The query you have posted bears no resemblance to what the error message is showing.

an insert query should be

INSERT INTO table CommaSeperatedFieldlist VALUES('comma', 'seperated','list','of values', 'in the' appropriate', 'order')

You appear to be attempting to insert one value to a table with specifying the field(s) it should be in.

NOW that is possible but your value list MUST be a complete one with ALL the values in the CORRECT ORDER for the table columns.

I solved it by removing the '' for the boolean value. Apparently, it causes some problems in the insert statement. Thanks

that would depend on the data type for the "boolean column"