i think using $message = nl2br($message)
after retrieve will do it.
To: php-objects@xxxxxxxxxxxxxxx
From: sridhar_vpy@xxxxxxxxxxx
Date: Wed, 21 Apr 2010 10:49:45 +0530
Subject: Re: Not getting the right output in phpmyadmin
try this while insert the record into database
<php?
$insert=mysql_ query("INSERT INTO form (email,subjetc, message)VALUES( '$email', '$subject' ,addslashes($message) ");
?>
while retrieve the message form database it will show what format you have inputed
stripslashes($message)
Sridhar
--- On Tue, 20/4/10, Gab Teo <doneatlast1000@xxxxxxxxx> wrote:
From: Gab Teo <doneatlast1000@xxxxxxxxx>
Subject: Not getting the right output in phpmyadmin
To: php-objects@xxxxxxxxxxxxxxx
Date: Tuesday, 20 April, 2010, 11:28 PM
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]
[Non-text portions of this message have been removed]
_________________________________________________________________
Hotmail: Free, trusted and rich email service.
https://signup.live.com/signup.aspx?id=60969
[Non-text portions of this message have been removed]
