One quick additional note -- if you use carriage returns in the
textarea, they'll be there in the database, but as a newline
character: \r or \n or \r\n
So if it's showing up as one line in your browser (which makes sense,
if you're using phpadmin) and you want to see the line breaks, what
you need to do is convert the newline characters into an html line
break before the database insert: <br />
--
Joe
On Apr 20, 2010, at 12:58 PM, Gab Teo wrote:
>
> Can someone help please?
>
> I use phpmyadmin and set the message field in the database with
> respect to id being that the id is in auto_increament:
>
> message (text)(latin1_swedish_ci)
>
> but, when when text is inputed into the database via the form it
> appeared as a straight line in the database and again when view
> from the browser is also appeard starightline, this causes the
> whole page to expand, I expected the message input to break after
> it reach cols=40 and continue in a new line until it reach the
> rows=10 as defined in the html form.
>
> Can someone help please?
>
> Gab
>
>
>
>
> <form action="mail.php" method="POST">
> <b>Email</b><br>
> <input type="text" name="email" size=40>
> <p><b>Subject</b><br>
> <input type="text" name="subject" size=40>
> <p><b>Message</b><br>
> <textarea cols=40 rows=10 name="message"></textarea>
> <p><input type="submit" value=" Send ">
> </form>
>
>
>
> <php?
> $insert=mysql_query("INSERT INTO form (email,subjetc,message)VALUES
> ('$email','$subject','$message'");
> ?>
[Non-text portions of this message have been removed]
