modcar Posted October 8, 2007 Share Posted October 8, 2007 * MYSQL 4.1 * insert into home values ('$content','$publisher'); * I was getting error message "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 ...." But now, no error messages * CREATE TABLE `d` ( `d1` TEXT NOT NULL ) CHARACTER SET = latin1; * I am trying to insert alot of text data into the table. I can insert up to about 2000 characters, after that it just doesn't insert to mysql. * I've tried changing the content feild to long text and medium text, still with no success Quote Link to comment https://forums.phpfreaks.com/topic/72285-inserting-data/ Share on other sites More sharing options...
fenway Posted October 9, 2007 Share Posted October 9, 2007 I assume there's php code that goes with this... Quote Link to comment https://forums.phpfreaks.com/topic/72285-inserting-data/#findComment-365098 Share on other sites More sharing options...
otuatail Posted October 10, 2007 Share Posted October 10, 2007 You create a table called d and want to insert into a table called home table d has only one field called d1 insertion to table has 2 fields. need more than this. Desmond. Quote Link to comment https://forums.phpfreaks.com/topic/72285-inserting-data/#findComment-366466 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.