Re: nl2br and BLOB field of MySQL

bsantos on 2002/09/25: Two solutions for your problem. You've got to manage them, anyway. There's nothing wrong with your code. PHP don't like the what I call: "direct nameset of variable"; just like $row[something] I rather do this: $new_var = $row[something] that way, always I use nl2br, all works fine. Anyway I do not use to put thinks in separated lines, like: $var = $var .= $var .= but checked that $var = "<td>nl2br($new_var)</td>"; works much better. If none of this work, try to checkout if you are not using thinks like this "<td align="center">"; instead of this: <td align=\"center\">"; or try to make a function { $nl_var = nl2br(something) }; bsantos Webmaster MFi "Jorge Pinto Leite" <jpleite@ip.pt> wrote in message news:20020830223435.8041.qmail@pb1.pair.com... > It's probably a problem of my code, can anyone help me? > I have a BLOB field in a MySQL table. This field is filled in a php page > with a <textarea>, where I can enter it formatted, with ENTER's to split > some lines from others. > In another page, this field is seen (not updated) - so I don't have a > <textarea> tag. > As I want to see the text exactly as entered, I have put the following code: > $res="<td><font..."; > $res.=nl2br($row[blobfield]); > $res.="</font></td>"; > echo ($res); > and the result is that I cannot see any part of the blob field. > If I change my code to > $res="<td><font..."; > $res.=$row[blobfield]; > $res.="</font></td>"; > echo ($res); > the complete blob field is seen, yet unformatted. > What am I doing wrong? > Thanks, > Jorge > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.384 / Virus Database: 216 - Release Date: 21-08-2002 > >