greggustin Posted July 13, 2006 Share Posted July 13, 2006 made a very simple DB1st table = no problem posing with html form => php => musql tablemade 2nd table = cannot insert dataget his error message:[color=red]posting of display test data I cannot connect to the database because: 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 ''test1.test1table2' (first,last,age)VALUES ('greg', 'gustin', '99')' at line 1[/color] Link to comment https://forums.phpfreaks.com/topic/14526-cannot-insert-into-2nd-table-in-data-base/ Share on other sites More sharing options...
akitchin Posted July 13, 2006 Share Posted July 13, 2006 looks to me like you're using single quotes around the table name when you shouldn't be. either use no quotes at all or use backticks (`). Link to comment https://forums.phpfreaks.com/topic/14526-cannot-insert-into-2nd-table-in-data-base/#findComment-57558 Share on other sites More sharing options...
kenrbnsn Posted July 13, 2006 Share Posted July 13, 2006 Please post your code surrounded by [nobbc][code][/code][/nobbc] tags.Ken Link to comment https://forums.phpfreaks.com/topic/14526-cannot-insert-into-2nd-table-in-data-base/#findComment-57563 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.