Returns now showing up in HTML

[Steve_Abrahall]

Hi

I have a nice little databaase spitting out records from mysql via php

only issue is that paragraph returns are not showing up in the HTML that is produced.

so a whole lot of text just runs together continually...

Any ideas what may be causing this?

Enclosed is the php file code_____

<?php
$db = mysql_connect("localhost", "bob","nanv69");
mysql_select_db("website1",$db);

$result = mysql_query("SELECT * FROM data1",$db);
echo "<TABLE>";
while($myrow = mysql_fetch_array($result))
{
echo "<TR width='70%'><TD td align='left' valign='top' >";
echo $myrow["tag"];
echo "<br><br>";
echo $myrow["body"];
echo "<H9>";
echo "<TD td align='right' valign='top'>";
echo "<br<br>";
echo $myrow["pic"];
echo "<TD td align='right' valign='top'>";

}
echo "</TABLE>";
echo "<br><br>Put link in eventualy to start and find all";

?>

[Kudose]

$myrow['pic']; is the right vairable. Not $myrow["pic"];

Also, if the $myrow variable calls HTML it will not be displayed becuase you echoed the variable like this

echo $myrow['pic'];

instead of

echo " $myrow['pic']; ";

It may also help to just name the pic like this

$pic = $myrow['pic'];

and call it like this

echo " $pic ";

Hope that clears a few things up.

[Steve_Abrahall]

Hmm not sure what I'm doing wrong but none of that worked (at leaset the way I was expecting it to ...)

The change in quote style was possible but the attepmt to re structure the code would break.....!

anyone else have any ideas?

Current PHP looks like this
Returns info but paragraphs ignored...

<?php
$db = mysql_connect("localhost", "root","sba5098");
mysql_select_db("website1",$db);

$result = mysql_query("SELECT * FROM data1",$db);
echo "<TABLE>";
while($myrow = mysql_fetch_array($result))

{
echo "<TR width='70%'><TD td align='left' valign='top' >";
echo $myrow['tag'];
echo "<br><br>";
echo $myrow ['body'];
echo "<TD td align='right' valign='top'>";
echo "<br<br>";
echo $myrow['pic'];
echo "<TD td align='right' valign='top'>";

}
echo "</TABLE>";
echo "<br><br>Put link in eventualy to start and find all";

?>

[LordShryku]

Returns meaning what? Like line breaks that should be there or the break tags you manually enter?

echo "<br<br>";
That won't work....

[Steve_Abrahall]

Ok
I'll try and create a visual example of what I mean. When I enter this text it's got paragraph returns in the text

Like this

and this

and this

when I get the text pumped into an html document via the php I'm using it looks

Like this and this and this

Interesting in that If I look at the samerecord / data in phpMyAdmin it views correctly

Like this

and this

and this

Hope this helps to explain the situation.

Steve

[LordShryku]

Use [man]nl2br[/man]

[jabi]

When are you closing your <tr> and <td>s? They are left open in your code as shown.

[Kudose]

I was gonna say exactly what jabi was. Blasts. 🙂

[Steve_Abrahall]

Originally posted by jabi
When are you closing your <tr> and <td>s? They are left open in your code as shown.

Ok

Code as it now stands is
and it's still not giving me returns! ;-(
Although it looks ok!

<?php
$db = mysql_connect("localhost", "bobey","brainhurts");
mysql_select_db("website1",$db);
$result = mysql_query("SELECT * FROM data1",$db);
echo "<TABLE width='60%'align='center'>";
while($myrow = mysql_fetch_array($result))
{
echo "<TR><TD align='left' valign='top'>";
echo $myrow['tag'];
echo "<br><br></td>";
echo "<td></td><td></td></tr><tr><td>";
echo $myrow ['body'];
echo "<br><br></td>";
echo "<td td align='right' valign='top'>";
echo $myrow['pic'];
echo "<td></tr>";
}
echo "</TABLE>";

I think I've got things closed off!¿

lordShryku While were on this
nl2br

How should the above be implemented?

I tried
echo nl2br $myrow ['body'];
with no luck

Strange!

[LordShryku]

It's a function, so it should be in parens

echo nl2br($myrow['body']);

[Kudose]

Try:

<?
$db = mysql_connect("localhost", "bobey","brainhurts"); 
mysql_select_db("website1",$db); 
$result = mysql_query("SELECT * FROM data1"); 
echo "<TABLE width='60%'align='center'>"; 
$num = mysql_num_rows($result);
for($i=0; $i<=$num; i++) 
{ 
$myrow = mysql_fetch_array($result)
echo "<TR><TD align='left' valign='top'>"; 
echo $myrow['tag']; 
echo "</td>"; 
echo "</tr><tr><td>"; 
echo $myrow ['body']; 
echo "</td>"; 
echo "<td td align='right' valign='top'>"; 
echo $myrow['pic']; 
echo "<td></tr>"; 
} 
echo "</TABLE>";

That was all freehanded, so there may be a parse error or two in it.

[Steve_Abrahall]

Ok

That didn't work

What's interesting is that
dadabik sort of Does Work!
http://www.dadabik.org/

It prints everything ok it looks fine but one of the things it's doing is printing returns with a <br> code inserted...(thats ok by me!no problem!)

I just need to know what dadabik is doing to make this happen !! It is a great application but getting inside the thing for a beginner is a bit daunting!

One other thing I found realy interesting was if I pump the record out put into a <textarea> </textarea> then the returns formatt correctly!

Can anyone throw any light on this?

TIA

Steve