#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    14
    Rep Power
    0
    Hi, I'm working on a weather web site and using php/mysql to enter city forecasts into a table.

    Everything is fine except my comment line.
    For some reason it only enters the first word I type in for the comment line.
    The line looks something like this:

    INSERT INTO one (cityname, day1, max1, min1, sky1, comments) VALUES ('boston', 'Saturday', '32', '23', 'sun.gif',
    'this')

    where comments is TEXT, I also tried varchar, char. (I use a <textarea> to enter the comment line)

    for the comment line above I had typed "this is a comment line", but only the "this" part of it shows up?

    Make sense???

    Thanks

    Mike
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    Pune, Maharashtra, India
    Posts
    86
    Rep Power
    14
    Just check out that whether u have given the maximum size of input or the size of the field as four. if so just increase it

Similar Threads

  1. Codepupil
    By Adachic in forum C Programming
    Replies: 3
    Last Post: February 6th, 2004, 06:50 PM
  2. Putting data into a string using a hidden field
    By Koz4k in forum HTML Programming
    Replies: 7
    Last Post: December 22nd, 2003, 03:12 AM
  3. Putting data into a string using a hidden field
    By Koz4k in forum PHP Development
    Replies: 2
    Last Post: December 18th, 2003, 07:00 AM
  4. string in mysql field..
    By netytan in forum MySQL Help
    Replies: 1
    Last Post: December 1st, 2003, 06:53 PM
  5. DBI warnings -- plz help
    By pranesh in forum Perl Programming
    Replies: 4
    Last Post: December 1st, 2003, 06:52 PM

IMN logo majestic logo threadwatch logo seochat tools logo