Sunday, 15 June 2014

php - Unable to write text in column SQL Error (1054): Unknown column in 'field list' -



php - Unable to write text in column SQL Error (1054): Unknown column in 'field list' -

i have test table few columns: aaa, bbb, ccc

for reason can write numbers values, text values ignored.

this code:

mysqli_query($con,"insert test (aaa, bbb, ccc) values ('sssss', 'aaaa',35)");

when executing this, column ccc gets value of 35, first columns empty.

i tried manually editing info heidisql , error :

sql error (1054): unknown column in 'field list'

when trying input text field. when input number works.

i tried different date types columns including: int,text, varchar didn't work.

what missing here?

edit:

i able write in text correctly setting date type.

php mysql sql heidisql

No comments:

Post a Comment