RE: Not getting the right output in phpmyadmin

[aridha alaradi <aridha@xxxxxxx>]

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]