query and nl2br()

[hermzz]

how can i use the nl2br() function in this piece of code?

$result=mysql_query("SELECT * FROM `post` ORDER BY `id` DESC") or die('MySQL error: '.mysql_error());
while($myrow = mysql_fetch_array($result, MYSQL_ASSOC)) {
printf("
<table width='550' border=0 cellpadding=0 cellspacing=0><tr> 
<td width='472' class='tableheader'>%s</td>
</tr>
<tr> 
<td class='tableentry' <br><br> %s -- %s <a href='index.php?main=comment&id=%s'>Comentarios</a></td>
</tr></table><br>", 
$myrow['titulo'], $myrow['texto'], $myrow['fecha'], $myrow['hora'], $myrow['id']);
}

if i put the nl2br() inside it'll display as text.

[Sxooter]

Originally posted by hermzz
how can i use the nl2br() function in this piece of code?

$result=mysql_query("SELECT * FROM `post` ORDER BY `id` DESC") or die('MySQL error: '.mysql_error());
while($myrow = mysql_fetch_array($result, MYSQL_ASSOC)) {
printf("
<table width='550' border=0 cellpadding=0 cellspacing=0><tr> 
<td width='472' class='tableheader'>%s</td>
</tr>
<tr> 
<td class='tableentry' <br><br> %s -- %s <a href='index.php?main=comment&id=%s'>Comentarios</a></td>
</tr></table><br>", 
$myrow['titulo'], $myrow['texto'], $myrow['fecha'], $myrow['hora'], $myrow['id']);
}

if i put the nl2br() inside it'll display as text. [/B]

that's probably either php getting confused by the big text string and not sure if you meant for it to be text or a function call. try breaking out your multi-line print into a couple, with the one at the bottom being:

print nl2br($myrow['titulo']);
etc...

[barand]

Or

$result=mysql_query("SELECT * FROM `post` ORDER BY `id` DESC") or die('MySQL error: '.mysql_error());
while($myrow = mysql_fetch_array($result, MYSQL_ASSOC)) {

$txt = nl2br($myrow['texto']);  // *** convert first ***

printf("
<table width='550' border=0 cellpadding=0 cellspacing=0><tr> 
<td width='472' class='tableheader'>%s</td>
</tr>
<tr> 
<td class='tableentry' <br><br> %s -- %s <a href='index.php?main=comment&id=%s'>Comentarios</a></td>
</tr></table><br>", 
$myrow['titulo'], $txt, $myrow['fecha'], $myrow['hora'], $myrow['id']);
}

[hermzz]

those are great ideas. thanks a lot.