You can't assign a value to a function! That's why attempt 1 didn't work. 
Well, that and: The value returned by mysql_query is NOT a string, it's a 
pointer to the values returned. You must fetch the string first to get the 
column values out. This is why your third attempt was the only one that 
actually had a chance of working. 

However, nl2br doesn't insert any \n's, it inserts a <br> tag for every \n. 
(actually <br />). I think that's what you meant, but it's helpful to be 

If it's displaying 25 rows (12 + 13), then that's likely how many rows are 
being returned by the database, you can check this by doing something like 

echo "<p>Number of rows returned by query: ".mysql_num_rows($result)."</p>";

before the table. If that displays 25, then your issue isn't your code, but 
extra data in the table, which is what I suspect the problem is. 

You also didn't close your while loop, but that's just a copy/paste error I 

You can also create the table with border=1 and this will let you see actual 
rows in the table, This loop will create 1 row for every row that's returned 
fromthe database, hinting at your issue. 

Hope that helps,

On Wednesday 01 March 2006 8:34 am, Jeff Broomall 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_array($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.
> Jeff
> ----- Original Message -----
> From: "Jeff Broomall" <[EMAIL PROTECTED]>
> To: <>
> Sent: Wednesday, March 01, 2006 9:00 AM
> Subject: [PHP-DB] Where did my Hard Returns go?
> 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.
> But 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.
> I checked within the MySQL database 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.
> --Jeff

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to