July 24th, 2000, 10:28 PM
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',
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?
July 28th, 2000, 09:23 AM
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