how to make it appear in mulit line like as in database

[dhivya]

I used

<textarea name="question" class="input" width="250"></textarea>

to add data in sql. i used multi line , in database also data is stored in multi line only.

Then i used

$question=$row['1'];
echo "<tr><td colspan='5'>",$row[1],"</td></tr>

to display the data but the data is displaying in single line.

How do I make it appear in multiple lines like as in database?

[Claus Mygind]

well for one thing you need to use periods . instead of comma , to concatenate your string like this:

wrong way
echo "<tr><td colspan='5'>",$row['1'],"</td></tr>";

right way
echo "<tr><td colspan='5'>".$row['1']."</td></tr>";

also how much text are you displaying. Here you are spanning 5 columns. Is the text you are streaming out longer than the width of the 5 columns?

[computerfox]

Are you trying to print out all the data returned by mysql?

What I normall do is:

<?php
  $getter=mysql_query();  //Query to grab all needed data
  while($info=mysql_fetch_assoc($getter)){
         //Print data
         //At this point, you can break the php and just use regular HTML
        //Note: when you want to print the data, you have to re-enter PHP
       //Note: you never HAVE to stay in pure PHP
 }

?>

[Dormilich]

wrong way
echo "<tr><td colspan='5'>",$ row['1'],"</td></tr>";

that’s actually a right way, works as well as concatenation.

//Note: you never HAVE to stay in pure PHP

but you should. breaking in and out of one language is bound to create confusion very very fast.

[Murat Bastas]

wrong way
echo "<tr><td colspan='5'>",$ row['1'],"</td></tr>";

Claus Mygind why wrong this way?

This is true in fact the use of...

[Claus Mygind]

Murat Bastas - Then what is the correct answer to dhivya question?

[Dormilich]

Although I’m not Murat Bastas, I hazard a guess at nl2br().

[Murat Bastas]

Php - Wordwrap() function , You need this.

Claus Mygind, my answer to that right?

[Murat Bastas]

nl2br function will work.

[Dormilich]

well, it seems like the line breaks are already there, they just don’t behave like they are assumed to do (because they follow the specification).

@Murat: you don’t need to quote me every time.