After doing further reading on google i have managed to get this working using the nl2br php command.
if anyone else wants to know how i did this.
almost the same as what was mentioned in this thread however my rows were being displayed using "while" command.
echo nl2br($row['colname']);
Thanks again for your assistance.
----------------------------------------
> From: ash@xxxxxxxxxxxxxxxxxxxx
> To: hansen.ross@xxxxxxxxxxx
> CC: php-general@xxxxxxxxxxxxx
> Date: Sat, 7 May 2011 10:32:11 +0100
> Subject: RE: html formatting in mysql post
>
> On Sat, 2011-05-07 at 16:01 +0800, Ross Hansen wrote:
>
> > thanks for your responses,
> >
> > so i understand that this code is using an array, however i havn't really used arrays as i am a novice php coder.
> > Should this code be used on the php code for inserting the data into the MySQL table or is it used when retrieving the data using the select function?
> >
> > > > // $row = /* Database row grabbed elsewhere in your code. */'';
> >
> > if (is_array($row)) {
> > foreach ($row as $r) {
> > echo nl2br($row).PHP_EOL;
> > }
> > } else {
> > echo nl2br($row).PHP_EOL;
> > }
> > ?>
> >
> > your help is appreciated.
> >
> > ----------------------------------------
> > > From: danbrown@xxxxxxx
> > > Date: Fri, 6 May 2011 23:04:44 -0400
> > > To: hansen.ross@xxxxxxxxxxx
> > > CC: php-general@xxxxxxxxxxxxx
> > > Subject: Re: html formatting in mysql post
> > >
> > > On Fri, May 6, 2011 at 22:52, Ross Hansen wrote:
> > > >
> > > > Hey Guys,
> > > >
> > > > I am using a form to post information to a MySQL table which is then echo(ing) back out to a web page. it will sort of be like facebook where you can post messages and stuff on peoples walls. The only issue is at the moment i can get the formatting to stay. When i echo the table out from mysql it all gets displayed on one line rather than seeing my new lines which i typed in the text box.
> > > > I do know that this is a HTML error as it was never given the format tags when the content was posted in the table.
> > > >
> > > > I have seen something about NL2BR and also something about strip slashes but i am not sure how to incorporate them into my post.
> > > >
> > > > Could someone please advise?
> > >
> > > Well, let's start with an easy question: have you *tried* them?
> > >
> > > >
> > > // $row = /* Database row grabbed elsewhere in your code. */'';
> > >
> > > if (is_array($row)) {
> > > foreach ($row as $r) {
> > > echo nl2br($row).PHP_EOL;
> > > }
> > > } else {
> > > echo nl2br($row).PHP_EOL;
> > > }
> > > ?>
> > >
> > > Error-handling and the remainder of checking is up to you.
> > >
> > > --
> > >
> > > Network Infrastructure Manager
> > > http://www.php.net/
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> >
>
>
>
> I think it would be well worth getting a book out on PHP or reading
> through the various online tutorials and the PHP manual. It will explain
> basic things like connecting to the database, using functions, echoing
> content to the screen, etc.
>
> --
> Thanks,
> Ash
> http://www.ashleysheridan.co.uk
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
