Unknown column 'Marc' in 'field list'

Discussion in 'PHP' started by easternBrain, Jul 19, 2007.

0
  1. #1
    Hello all.. As you can see I am having an error in my php script... the error happens when i am inserting data in my database,

    the code is:
    INSERT INTO employess(custID,emplFirstName,emplLastName,emplBirthDate) VALUES(1,Marc,Witney,19832303)

    the php error is, "the error is: Unknown column 'Marc' in 'field list'".

    I have looked online for this, and i have read that it happens in 5.X when using left joins, however i am not, so I can not find any information on this. Could some one help.
     
    easternBrain, Jul 19, 2007 IP
  2. nico_swd

    nico_swd Prominent Member

    Messages:
    4,153
    Likes Received:
    344
    Best Answers:
    18
    Trophy Points:
    375
    #2 
    
INSERT INTO employess
    (custID,emplFirstName,emplLastName,emplBirthDate)
VALUES
    (1,'Marc','Witney',19832303)
    Code (sql):
    The string values you want to enter need to be enclosed in quotes.
     
    nico_swd, Jul 19, 2007 IP