Asheeown Posted January 28, 2007 Share Posted January 28, 2007 [code]$Insert = "INSERT INTO Users (UserID, Name, Password, OriginatingTG, Additional_ID, Email, Group) VALUES ('', '$Name', '$Password', '$OriginatingTG', '$Additional_ID', '$Email', '$Group')";$Insert = mysql_query($Insert) or die(mysql_error());[/code]Error:[quote]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) VALUES ('', 'Bob', '64b19694e6236b179e5f1a8fe0c8c95f', '000500', '', 'Dan' at line 1[/quote]It has to be near "Group) Values"Is their something that i'm missing? Link to comment https://forums.phpfreaks.com/topic/36046-mysql-insert-query/ Share on other sites More sharing options...
matto Posted January 28, 2007 Share Posted January 28, 2007 as the word "group" is a reserved SQL keyword, put back-ticks around the word group......[code]`group`[/code] ;) Link to comment https://forums.phpfreaks.com/topic/36046-mysql-insert-query/#findComment-171087 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.