Re: Re: textarea with multiple rows and mysql insert

I'm using post Here's the code: --- <html> <head><title>Detalles</title></head> <body bgcolor="white"> <form method="post" action="editarsoftsel.2.php"> <table> [...] <tr> <td><font>Manuales:</font></td> <td><textarea name="manuales" rows="2" cols="50"><? echo $formVars["mansycontrato"] . "http://"; ?></textarea></td> </tr> <tr> <td><font>Comentarios:</font></td> <td><textarea name="comentarios" rows="5" cols="50"><? echo $formVars["comentarios"]; ?></textarea></td> </tr> <tr> <td><br><input type="image" src="enviar.gif" border="0"> <INPUT name="submit" type="hidden" value="1"></td> </tr> </table> </form> </body> </html> --- --- George Patterson <george@visp.com.au> wrote: > On Sun, 12 Oct 2003 23:31:55 -0700 (PDT) > Jason End <bensnephew@yahoo.com> wrote: > > > 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 > > > Jason, > > Are you using the get or post form method?? If the > method isn't > specified, browser will default to Get. The get > method is will truncate > the data from the browser, whereas the Post method > will allow alot more. > > Consider posting back the html for the form. > > The other possiblity is that you have carriage > returns comming back from > the form that you need to parse out. > > George Patterson > > > --- 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 > mysqlinsert > > > >> 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? > > > >> > > -- > 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