Re: Re: textarea with multiple rows and mysql insert

The type was already set to "text". The problem isn't at the mysql level but at the form/php level. The insert statement that is formed extracting the values from the form is only giving that part of the url or comments. Jay --- Dan Brunner <daniel.brunner@duni.com> wrote: > What is your field length??? > > > Varchar(10)?? > > You should set the column type to text. > > > Dan > > > > On Oct 10, 2003, at 10:27 AM, joao@mrmidia.com.br > wrote: > > > > >> I have a form that includes two text areas that > span > >> multiple rows. The first textarea (rows=2, > cols=50) is > >> used to insert a pretty long url, while the > second > >> (rows=5, cols=50) is used for inserting free text > >> (comments). > >> When I process the form to create the mysql > insert > >> statement, the values inserted for both those > text > >> areas get cut off after the end of each row. > >> How can I get the script to process the full > contents? > >> > >> thanks > >> > >> __________________________________ > >> Do you Yahoo!? > >> Yahoo! SiteBuilder - Free, easy-to-use web site > design software > >> http://sitebuilder.yahoo.com > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: > http://www.php.net/unsub.php > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com