Inserting data

[modcar]

    * 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

 

[fenway]

I assume there's php code that goes with this...

[otuatail]

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.