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 ? Link to comment https://forums.phpfreaks.com/topic/235699-php-help/ 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` Link to comment https://forums.phpfreaks.com/topic/235699-php-help/#findComment-1211438 Share on other sites More sharing options...
dannybrazil Posted May 6, 2011 Author Share Posted May 6, 2011 thanks!! Link to comment https://forums.phpfreaks.com/topic/235699-php-help/#findComment-1211440 Share on other sites More sharing options...
fugix Posted May 6, 2011 Share Posted May 6, 2011 no problem Link to comment https://forums.phpfreaks.com/topic/235699-php-help/#findComment-1211441 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.