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