MadDawgX Posted February 5, 2007 Share Posted February 5, 2007 Hey there. What's wrong with the following syntax: $qPost = "INSERT INTO chat (cat,by,rank,mes) VALUES ('$ChatPage','$LogUsername','$LogRank','$NewChat')"; $rPost = mysql_query($qPost) or die('Query failed. ' . mysql_error()); It's throwing: Query failed. 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 'by,rank,mes) VALUES ('1','AlcanderX','4','Test')' at line 1 Link to comment https://forums.phpfreaks.com/topic/37093-mysql-query-problem/ Share on other sites More sharing options...
btherl Posted February 5, 2007 Share Posted February 5, 2007 It's probably a reserved word.. try INSERT INTO chat (cat,`by`,rank,mes) ... Link to comment https://forums.phpfreaks.com/topic/37093-mysql-query-problem/#findComment-177168 Share on other sites More sharing options...
fenway Posted February 5, 2007 Share Posted February 5, 2007 Better yet, pick a better column name. Link to comment https://forums.phpfreaks.com/topic/37093-mysql-query-problem/#findComment-177206 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.