hard returns

Sorry if this is the wrong newsgroup, but I couldn't see a better one.

I'm having a 'simple' problem with MYSQL.

I have a block of text that I want to input all together in one cell of
data - say a long review of software. I want that long text to be split up
into paragraphs having hard returns between them. But. I dont want to have
to input <br> after the paragraph end myself, I would like MYSQL to do it
for me.

The filed in the MYSQL database where the review would be kept is:

Field Type Length/Values Collation
Content longtext latin1_swedish_ci


Attributes Null Default Extra Comments
Null Null


As I'm not an expert at MYSQL I cant see how to do what I want and the
manual is as clear as mud.

Any help would be appreciated.

Thanks.



--
Posted via a free Usenet account from http://www.teranews.com

F9 wrote:
> Sorry if this is the wrong newsgroup, but I couldn't see a better one.
>
> I'm having a 'simple' problem with MYSQL.
>
> I have a block of text that I want to input all together in one cell of
> data - say a long review of software. I want that long text to be split up
> into paragraphs having hard returns between them. But. I dont want to have
> to input <br> after the paragraph end myself, I would like MYSQL to do it
> for me.
>
> The filed in the MYSQL database where the review would be kept is:
>
> Field Type Length/Values Collation
> Content longtext latin1_swedish_ci
>
>
> Attributes Null Default Extra Comments
> Null Null
>
>
> As I'm not an expert at MYSQL I cant see how to do what I want and the
> manual is as clear as mud.
>
> Any help would be appreciated.
>
> Thanks.
>
>
>

You could do it in MySQL, but I think you'd be better off doing it in
whatever language you're using.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:uuOdnZvX6chEmeXYnZ2dnUVZ_tWdnZ2d@comcast.com. ..
> F9 wrote:
>> Sorry if this is the wrong newsgroup, but I couldn't see a better one.
>>
>> I'm having a 'simple' problem with MYSQL.
>>
>> I have a block of text that I want to input all together in one cell of
>> data - say a long review of software. I want that long text to be split
>> up
>> into paragraphs having hard returns between them. But. I dont want to
>> have
>> to input <br> after the paragraph end myself, I would like MYSQL to do it
>> for me.
>>
>> The filed in the MYSQL database where the review would be kept is:
>>
>> Field Type Length/Values Collation
>> Content longtext
>> latin1_swedish_ci
>>
>>
>> Attributes Null Default Extra Comments
>> Null Null
>>
>>
>> As I'm not an expert at MYSQL I cant see how to do what I want and the
>> manual is as clear as mud.
>>
>> Any help would be appreciated.
>>
>> Thanks.
>
> You could do it in MySQL, but I think you'd be better off doing it in
> whatever language you're using.

To be honest I am new at this. I set up the MYSQL database with the field
above and use a PHP design program called "Easygen 2.3" to call the data
into a template. This is probably an idiots tool as I cant program directly
in PHP.

I have looked through its "style sheet editor" and help but there's nothing
on hard returns. If I knew what to add to the script I could probably do so
by trial and error.

I'm going to try one more thing, so will let you know.

Thanks for help so far.



--
Posted via a free Usenet account from http://www.teranews.com

"F9" <Me@freeinternet.com> wrote in message
news:45780f3a$0$15453$88260bb3@free.teranews.com.. .
> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
> news:uuOdnZvX6chEmeXYnZ2dnUVZ_tWdnZ2d@comcast.com. ..
>> F9 wrote:
>>> Sorry if this is the wrong newsgroup, but I couldn't see a better one.
>>>
>>> I'm having a 'simple' problem with MYSQL.
>>>
>>> I have a block of text that I want to input all together in one cell of
>>> data - say a long review of software. I want that long text to be split
>>> up
>>> into paragraphs having hard returns between them. But. I dont want to
>>> have
>>> to input <br> after the paragraph end myself, I would like MYSQL to do
>>> it
>>> for me.
>>>
>>> The filed in the MYSQL database where the review would be kept is:
>>>
>>> Field Type Length/Values Collation
>>> Content longtext latin1_swedish_ci
>>>
>>>
>>> Attributes Null Default Extra Comments
>>> Null Null
>>>
>>>
>>> As I'm not an expert at MYSQL I cant see how to do what I want and the
>>> manual is as clear as mud.
>>>
>>> Any help would be appreciated.
>>>
>>> Thanks.
>>
>> You could do it in MySQL, but I think you'd be better off doing it in
>> whatever language you're using.
>
> To be honest I am new at this. I set up the MYSQL database with the field
> above and use a PHP design program called "Easygen 2.3" to call the data
> into a template. This is probably an idiots tool as I cant program
> directly in PHP.
>
> I have looked through its "style sheet editor" and help but there's
> nothing on hard returns. If I knew what to add to the script I could
> probably do so by trial and error.
>
> I'm going to try one more thing, so will let you know.
>
> Thanks for help so far.

Got this sorted via the Easygen program. Thanks.



--
Posted via a free Usenet account from http://www.teranews.com