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
specific.
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
this:
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
bet.
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,
-Micah
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" <news@xxxxxxxxxxx>
> To: <php-db@xxxxxxxxxxxxx>
> Sent: Wednesday, March 01, 2006 9:00 AM
> Subject: 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 (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
