nutstretch Posted September 29, 2008 Share Posted September 29, 2008 I have a table i am trying to insert some data into and I am getteing the following error' "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 'Desc, addedby ) VALUES( 'test', 'this test', 'angie' )' at line 1" my code is: $result = mysql_query("INSERT INTO scheme( name, Desc, addedby ) VALUES( '$scheme', '$desc', '$user' )", $linkID)or die(mysql_error()); the fields in my table are name, Desc, addedby Please can anyone see an obvious error as I can't Hoping one day to create something useful. Nuts Link to comment https://forums.phpfreaks.com/topic/126272-solved-insert-problem/ Share on other sites More sharing options...
nutstretch Posted September 29, 2008 Author Share Posted September 29, 2008 I have solved this. It did not like the name of one of my fields as it was a designated word 'Desc' Link to comment https://forums.phpfreaks.com/topic/126272-solved-insert-problem/#findComment-652915 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.