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] Quote Link to comment 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 (`). Quote Link to comment 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 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.