Unknown column 'a01' in 'field list'

it is a simple insert statement:
insert into cd (no, title, topic, author, publisher) values (a01, b02, c03, d04, e05);

but i got the error
db is mysql...

wt's wrong?
any help??

    You must remember to 'quote' values

      2 months later

      hi, i have a similar problem. I read these other threads too
      http://www.phpbuilder.com/board/showthread.php?s=&threadid=10228875&highlight=unknown+column+in+field+list
      http://www.phpbuilder.com/board/showthread.php?s=&threadid=10216562&highlight=unknown+column+in+field+list

      I tried to quote all the values for the columns. but still doesn't work. also when i tried to quote some values like 1, the values changed to different number. here's my error

      DB Error: Bad SQL Query: INSERT INTO 4images_users (user_id, user_level, user_name, user_password, user_email, user_showemail, user_allowemails, user_invisible, user_joindate, user_activationkey, user_lastaction, user_lastvisit, user_comments, user_homepage, user_icq) VALUES (2, 2, 'gurl', 'edbd0effac3fcc98e725920a512881e0', 'aznvcutie@hotmail.com', 1, 1, 0, 1052674296, 'c052c39aa26bc777e5f78cb108e29060', 1052674296, 1052674296, 0, '', '')
      Unknown column 'user_homepage' in 'field list'

      and here's what i supposed to put in for the values;

      INSERT INTO 4images_users (user_id, user_level, user_name, user_password, user_email, user_showemail, user_allowemails, user_invisible, user_joindate, user_activationkey, user_lastaction, user_location, user_lastvisit, user_comments, user_homepage, user_icq) VALUES (-1,-1,'Guest','0493984f537120be0b8d96bc9b69cdd2','',0,0,0,0,'',0,'',0,0,'','');
      INSERT INTO 4images_users (user_id, user_level, user_name, user_password, user_email, user_showemail, user_allowemails, user_invisible, user_joindate, user_activationkey, user_lastaction, user_location, user_lastvisit, user_comments, user_homepage, user_icq) VALUES (1,9,'admin','21232f297a57a5a743894a0e4a801fc3','admin@yourdomain.com',1,1,0,1016023608,'1e3457c0b2052a9633b886fd75ef91e0',1016023608,'',0,0,'','');

      as u can see the problem is at user_homepage, but i'm not supposed to put values in there.

        Write a Reply...