dennismonsewicz Posted March 24, 2009 Share Posted March 24, 2009 I have been staring at this for quite sometime now and cannot figure out what my problem is... its been a very long morning already lol... $sql = mysql_query("INSERT INTO jos_chronoforms_9 ('daterec','status','details','requestor','comments') VALUES ('$date', '$status', '$details', '$requestor', '$comments')")or die(mysql_error()); I am getting this error message: 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 ''daterec','status','details','requestor','comments') VALUES ('hj', 'jlh', 'jlh',' at line 1 Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted March 24, 2009 Share Posted March 24, 2009 field names should be wrapped in backticks (eg `field_name`) not quotes. Quote Link to comment Share on other sites More sharing options...
dennismonsewicz Posted March 24, 2009 Author Share Posted March 24, 2009 wow can't believe i missed it... tks! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.