# nl2br help

**URL:** https://forum.kirupa.com/t/nl2br-help/238298
**Category:** programming
**Created:** [September 9, 2007, 4:07pm UTC](https://forum.kirupa.com/t/nl2br-help/238298 "2007-09-09T16:07:21Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![VonGizzle](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/vongizzle/32/3948_2.png) [@VonGizzle](https://forum.kirupa.com/u/VonGizzle)
#### Post date: [September 9, 2007, 4:07pm UTC](https://forum.kirupa.com/t/nl2br-help/238298/1 "2007-09-09T16:07:21Z")

</div>

Hi guys,

I’m aware of the theory behind nl2br, but I can’t seem to get it working within this while loop.

\<?php

include(“connect.php”);

$showrecord = “Select \* from news”;  
$recordC = mysql\_query($showrecord,$connect);

while ($row = mysql\_fetch\_array($recordC, MYSQL\_NUM))  
{  
printf("\<p\>%s\<p\>", $row[1]);  
echo ‘\<a href="news\_edit.php?id=’.$row[0].’"\>Edit\</a\>’;  
}

mysql\_free\_result($recordC);

mysql\_close($connect);

?\>

Any ideas?