dannybrazil Posted May 6, 2011 Share Posted May 6, 2011 Can anybody help me here, I have this code that I have NO clue whats wrong, in other pages it it working if ($_POST['submit'] == 'Edit Report') { $id = $_REQUEST['id']; $group = $_POST['group']; $group_clean = mysql_real_escape_string($group); $report = $_REQUEST['report']; $report_clean = mysql_real_escape_string($report); mysql_query(" UPDATE teacher_report SET group='$group_clean' , report='$report_clean' WHERE id=$id ") or die(mysql_error()); header("Location: report.php?msg=Your report was edited Successfully!"); exit; } I get this 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 'group='Gestamphhh' , report='checking' WHERE id=1' at line 1 help ? Quote Link to comment Share on other sites More sharing options...
fugix Posted May 6, 2011 Share Posted May 6, 2011 you are receiving this error because "group" is a mysql reserved word, and cannot be used to name your field...to remedy this, you can either change the name of the field, or you can place the field name in backticks...eg. `group` Quote Link to comment Share on other sites More sharing options...
dannybrazil Posted May 6, 2011 Author Share Posted May 6, 2011 thanks!! Quote Link to comment Share on other sites More sharing options...
fugix Posted May 6, 2011 Share Posted May 6, 2011 no problem 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.