Where did my Hard Returns go?

[ward]

Good morning.

I created an edit_task page that allows the user to edit tasks for the
database. I entered some text and used some hard returns.

Put when I went to view the tasks (using a PHP script if it matters),
the hard returns didn't "take." None of em. All of the text is
jumbled together.

Well I checked within the MySQL database just now (before uploading
this message) and noticed the Hard Returns show in the database (at
least while using phpMyAdmin).

Must have something to do with PHP? Where did I go wrong???

Thanks.

--Ward

[David Haynes]

ward@ wrote:

Good morning.

I created an edit_task page that allows the user to edit tasks for the
database. I entered some text and used some hard returns.

Put when I went to view the tasks (using a PHP script if it matters),
the hard returns didn't "take." None of em. All of the text is
jumbled together.

Well I checked within the MySQL database just now (before uploading
this message) and noticed the Hard Returns show in the database (at
least while using phpMyAdmin).

Must have something to do with PHP? Where did I go wrong???

Thanks.

--Ward

What are you using to view the data? A browser or a terminal session?
If a browser, are your 'hard returns' coded as <br> or <br/>?
If a terminal session, are your 'hard returns' coded as \r\n or just \n?

-david-

[ward]

David, thank you for asking.

I'm using MSIE 6.x to view.

I'm not sure if we're on the same page. I know about using <BR> and
<br/> within the browser (if we're talking about the same thing) but
it's the output from the database that isn't working. Somehere
between the database and output using PHP I loose the hard returns.

For example, if I was to enter...

Topic A

Now is the time for all men

to come to the aid of their nation.

That's who it would show up in the database, but trying to output it
into my page it'll look like...

Topic A Now is the time for all men to
come to the aid of their nation.

I hope that helps.

Ward
On Wed, 01 Mar 2006 09:05:09 -0500, David Haynes
<da***********@ sympatico.ca> wrote:

ward@ wrote:

Good morning.

I created an edit_task page that allows the user to edit tasks for the
database. I entered some text and used some hard returns.

Put when I went to view the tasks (using a PHP script if it matters),
the hard returns didn't "take." None of em. All of the text is
jumbled together.

Well I checked within the MySQL database just now (before uploading
this message) and noticed the Hard Returns show in the database (at
least while using phpMyAdmin).

Must have something to do with PHP? Where did I go wrong???

Thanks.

--Ward

What are you using to view the data? A browser or a terminal session?
If a browser, are your 'hard returns' coded as <br> or <br/>?
If a terminal session, are your 'hard returns' coded as \r\n or just \n?

-david-

[frizzle]

ward@ wrote:

Good morning.

I created an edit_task page that allows the user to edit tasks for the
database. I entered some text and used some hard returns.

Put when I went to view the tasks (using a PHP script if it matters),
the hard returns didn't "take." None of em. All of the text is
jumbled together.

Well I checked within the MySQL database just now (before uploading
this message) and noticed the Hard Returns show in the database (at
least while using phpMyAdmin).

Must have something to do with PHP? Where did I go wrong???

Thanks.

--Ward

before printing the results from the DB, you should call nl2br() (
NewLine To Break )

print nl2br( $result['text'] );

More info at http://php.net/nl2br

Frizzle.

[Jerry Stuckle]

ward@ wrote:

David, thank you for asking.

I'm using MSIE 6.x to view.

I'm not sure if we're on the same page. I know about using <BR> and
<br/> within the browser (if we're talking about the same thing) but
it's the output from the database that isn't working. Somehere
between the database and output using PHP I loose the hard returns.

For example, if I was to enter...

Topic A

Now is the time for all men

to come to the aid of their nation.

That's who it would show up in the database, but trying to output it
into my page it'll look like...

Topic A Now is the time for all men to
come to the aid of their nation.

I hope that helps.

Ward
On Wed, 01 Mar 2006 09:05:09 -0500, David Haynes
<da***********@ sympatico.ca> wrote:

ward@ wrote:

Good morning.

I created an edit_task page that allows the user to edit tasks for the
database. I entered some text and used some hard returns.

Put when I went to view the tasks (using a PHP script if it matters),
the hard returns didn't "take." None of em. All of the text is
jumbled together.

Well I checked within the MySQL database just now (before uploading
this message) and noticed the Hard Returns show in the database (at
least while using phpMyAdmin).

Must have something to do with PHP? Where did I go wrong???

Thanks.

--Ward

What are you using to view the data? A browser or a terminal session?
If a browser, are your 'hard returns' coded as <br> or <br/>?
If a terminal session, are your 'hard returns' coded as \r\n or just \n?

-david-

Ward,

Look at the source code for your page. You'll see your newlines there.
And the browser is completely free to ignore them.

If you want newline characters, you need to use <br>. Check out nl2br().

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[ward]

On 1 Mar 2006 06:22:40 -0800, "frizzle" <ph********@gma il.com> wrote:

before printing the results from the DB, you should call nl2br() (
NewLine To Break )

print nl2br( $result['text'] );

More info at http://php.net/nl2br

Frizzle.

I'll visit the link, thanks.

I looked at the source of the output page. And the breaks are there
including new lines and spaces between new lines.

BTW, what are the technical terms for...

Topic A
This is topic A <--- new line but no space (I guess like <BR>)

and

Topic A
<--- new line and space (I guess like <p>)
This is topic A.

So I guess a question is, what is stored to represent a new line AND a
new line with a space.

I guess it's \n for a new line but is it \n\n for a space?

Ok, the next question is, where do I call this function?

On $result from $result = mysql_query ($query); // Run the query.

or

somewhere within this statement...

$bg = '#eeeeee'; // Set the background color.
while ($row = mysql_fetch_arr ay($result, MYSQL_ASSOC)) {
$bg = ($bg=='#eeeeee' ? '#ffffff' : '#eeeeee'); // Switch the
background color.
echo '<tr valign="top" bgcolor="' . $bg . '">
<td align="left"><a href="edit_task _v5.php?id=' .
$row['task_id'] . '">Edit</a></td>
<td align="left">' . $row['task_task_no'] . '</td>
<td align="left">' . $row['icaotask_no'] . '</td>
<td align="left">' . $row['task_usaction'] . '</td>
</tr>
';

Thanks.

Ward

[ward]

As for an update...

Through trial-and-error, I've determined the following don't work...

Attempt 1:

nl2br($result) = mysql_query ($query); // Run the query.

Attempt 2:

$result = mysql_query ($query); // Run the query.
$result = nl2br($result)

Attempt 3:

$bg = '#eeeeee'; // Set the background color.
while ($row = mysql_fetch_arr ay($result, MYSQL_ASSOC)) {
$bg = ($bg=='#eeeeee' ? '#ffffff' : '#eeeeee'); // Switch the
background color.
echo nl2br( '<tr valign="top" bgcolor="' . $bg . '">
<td align="left"><a href=edit_task. php?id=' .
$row['task_id'] . '">Edit</a></td>
<td align="left">' . $row['task_task_no'] . '</td>
<td align="left">' . $row['icaotask_no'] . '</td>
<td align="left">' . $row['task_usaction'] . '</td>
</tr>
');

Now, attempt 3 kind of worked. It did insert the \n but it almost
doubled the size of the table. IOW, instead of 13 rows (the correct
number of rows), it stated the table off with 12 empty rows
(alternating between the two color shades) and then displayed the 13
correct rows.

Perhaps this was the proper placement of nl2br but there is something
in the other code that screwed up the presentation???

Thanks.

Ward

[Jerry Stuckle]

ward@ wrote:

As for an update...

Through trial-and-error, I've determined the following don't work...

Attempt 1:

nl2br($result) = mysql_query ($query); // Run the query.

Attempt 2:

$result = mysql_query ($query); // Run the query.
$result = nl2br($result)

Attempt 3:

$bg = '#eeeeee'; // Set the background color.
while ($row = mysql_fetch_arr ay($result, MYSQL_ASSOC)) {
$bg = ($bg=='#eeeeee' ? '#ffffff' : '#eeeeee'); // Switch the
background color.
echo nl2br( '<tr valign="top" bgcolor="' . $bg . '">
<td align="left"><a href=edit_task. php?id=' .
$row['task_id'] . '">Edit</a></td>
<td align="left">' . $row['task_task_no'] . '</td>
<td align="left">' . $row['icaotask_no'] . '</td>
<td align="left">' . $row['task_usaction'] . '</td>
</tr>
');

Now, attempt 3 kind of worked. It did insert the \n but it almost
doubled the size of the table. IOW, instead of 13 rows (the correct
number of rows), it stated the table off with 12 empty rows
(alternating between the two color shades) and then displayed the 13
correct rows.

Perhaps this was the proper placement of nl2br but there is something
in the other code that screwed up the presentation???

Thanks.

Ward

Ward,

Just use nl2br() on the data from the database which has newlines not
the entire table, i.e.

echo '<tr valign="top" bgcolor="' . $bg . '">
<td align="left"><a href=edit_task. php?id=' .
$row['task_id'] . '">Edit</a></td>
<td align="left">' . $row['task_task_no'] . '</td>
<td align="left">' . $row['icaotask_no'] . '</td>
<td align="left">' . nl2br($row['task_usaction']) . '</td>
</tr>';

if only $row['task_usaction'] has the newlines.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[ward]

On Wed, 01 Mar 2006 11:40:45 -0500, Jerry Stuckle
<js*******@attg lobal.net> wrote:

Jerry, thank you.

I don't know why I didn't try that.

I get wrapped around the axle and don't see the trees from the forest.
IOW, I forgot that $row['task_usaction'] is the variable.

Anyhow, thanks again. Looks like I need to learn the very basics of
programming.

I may have another challange if you wish to take a looksee. It is
more complicated than this.

--Ward

Ward,

Just use nl2br() on the data from the database which has newlines not
the entire table, i.e.

echo '<tr valign="top" bgcolor="' . $bg . '">
<td align="left"><a href=edit_task. php?id=' .
$row['task_id'] . '">Edit</a></td>
<td align="left">' . $row['task_task_no'] . '</td>
<td align="left">' . $row['icaotask_no'] . '</td>
<td align="left">' . nl2br($row['task_usaction']) . '</td>
</tr>';

if only $row['task_usaction'] has the newlines.

[william.clarke]

Just one point Ward, it is a good idea to use <br> or even better to
use <br />, that way your page is XHTML compliant.