insert new lines in column of a table 1

[niceguy606]

Hi
i have a table where i have 2 columns

table

AutoID(int) ServiceNotes(Text)
1 Visit-1:Test1
Visit-2 Test2

2 Visit-10:test3

whenever insert a row into this table.It should put the first notes in first line and whenever i add more notes it should go to next line in the ServiceNotes column

how to do it

pls let me know

thanks

 

[OrganizedChaos]

Just so we are clear, when you say "insert row", you are talking about inserting a new id with new notes?

And when you say "add more notes" you are talking about updating a current row? IE: add to the existing data already there?

 

[niceguy606]

Adding data the existing data not adding new row.

 

[DRJ478]

I assume you hit the enter key between the notes in the column for the notes.
For display purposes you should just use nl2br($row['ServiceNotes'])and the newline chars will be converted to <br /> tags.

 

[niceguy606]

How to add the enter key in the column using update statement when i add more notes to it?

can you pls give me the syntax for it.
thanks

 

[DRJ478]

All you need is a newline character. In PHP you can create that with doublequotes and "\n".

$text = "Hi there.";
$text .= "\nAnother line";
$text .= "\nYet another line";

echo nl2br($text);

Ok?

 

[hos2]

$servicenotes=$servicenotes .$post_["yournewnotevarhere"] . '<br>'

 

[niceguy606]

hi
i tried ur suggestions both of them print <br /> in the text area or <br> tag when i display in the text area on the form.

how to do it

pls
thanks

 

[DRJ478]

a) When you have to display the data in a table - that is in the HTML context - then use nl2br before displaying it.

b) When you use the data to populate a <textarea> then do not use the nl2br as the newlines will be correctly rendered without the need to convert them to <br /> tags.

So, all depends on the context.