syntax error

[conan318]

all was working in till i added the last 3 items into the query. lock,pri,high.

all 3 variables echo out the right value.

remove the last 3 works fine.

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 'lock,pri,high) VALUES ('tom@mydomain','tom','logo Design','add add'' at line 1

 

$result=mysql_query("INSERT INTO listing (email,listing_name,listing_type,listing_description,budget,ivn,link1,link2,link3,slide,slide2,slide3,slide4,slide5,slide6,expiredate,zip,lock,pri,high) VALUES ('$email','$listing_name','$dtype','$description','$budget','$inv2','$link1','$link2','$link3','$slide','$slide2','$slide3','$slide4','$slide5','$slide6','$newdate','$img','$lock','$pri','$high')") or die (mysql_error());

[conan318]

changed the table to invite and all is working now... notsure why it did like me using the word lock.

 

$result=mysql_query("INSERT INTO listing (email,listing_name,listing_type,listing_description,budget,ivn,link1,link2,link3,slide,slide2,slide3,slide4,slide5,slide6,expiredate,zip,pri,high,invite) VALUES ('$email','$listing_name','$dtype','$description','$budget','$inv2','$link1','$link2','$link3','$slide','$slide2','$slide3','$slide4','$slide5','$slide6','$newdate','$img','$pri','$high','$invite')") or die (mysql_error());

 

 

[trq]

lock is a reserved word in mysql. Either change your column name or surround it with `backticks`.

[conan318]

thanks for clearing that up.

 

will lock that in the memory bank

 

wasted hours looking for a syntax error lol

[AyKay47]

you should familiarize yourself with the mysql reserved words so you do not run into this again.