Parsing MySQL query return

[John]

Hey All,

I have a question regarding parsing text from a MySQL query. Basically, I
have several paragraphs of text in a field in MySQL. I run a query, get the
results, no problem. However, I would like to only display the first
paragraph of the data returned.

What is the best way to do this?

Thanks,
John

[Ewout De Boer]

----- Original Message -----
From: "John" <jpoz@quickscribble.com>
To: <php-general@lists.php.net>
Sent: Monday, July 28, 2003 8:22 PM
Subject: [PHP] Parsing MySQL query return

> Hey All,
>
> I have a question regarding parsing text from a MySQL query. Basically, I
> have several paragraphs of text in a field in MySQL. I run a query, get

the

> results, no problem. However, I would like to only display the first
> paragraph of the data returned.
>
> What is the best way to do this?

That depends on te format of the text/paragraphs in the mysql field.
How are the paragraphs separated ?



regards,
Ewout

[John]

I'm using someone elses data here (inheriting). But it looks like it was
typed into the field, possibly using PHPMyADMIN. I would assume the
paragraphs are just seperated by carriage returns. Is there a way to tell
for sure?

John


"Ewout De Boer" <ewout@chemistry-interactive.nl> wrote in message
news:005901c3553a$0751eea0$0200410a@soyuz...

> ----- Original Message -----
> From: "John" <jpoz@quickscribble.com>
> To: <php-general@lists.php.net>
> Sent: Monday, July 28, 2003 8:22 PM
> Subject: [PHP] Parsing MySQL query return
>
>

> > Hey All,
> >
> > I have a question regarding parsing text from a MySQL query. Basically,

I

> > have several paragraphs of text in a field in MySQL. I run a query, get

> the

> > results, no problem. However, I would like to only display the first
> > paragraph of the data returned.
> >
> > What is the best way to do this?

>
> That depends on te format of the text/paragraphs in the mysql field.
> How are the paragraphs separated ?
>
>
>
> regards,
> Ewout
>

[Nicholas Robinson]

If you assume either \n or \n\n as the para delimiters then you could use
strpos (see function.strpos.html) to work out where to split the text. If the
text field contents are huge, you might consider limiting the query results
by using left( field, size ) in the query.

KR

N
On Monday 28 Jul 2003 7:57 pm, Ewout de Boer wrote:

> ----- Original Message -----
> From: "John" <jpoz@quickscribble.com>
> To: <php-general@lists.php.net>
> Sent: Monday, July 28, 2003 8:22 PM
> Subject: [PHP] Parsing MySQL query return
>

> > Hey All,
> >
> > I have a question regarding parsing text from a MySQL query. Basically, I
> > have several paragraphs of text in a field in MySQL. I run a query, get

>
> the
>

> > results, no problem. However, I would like to only display the first
> > paragraph of the data returned.
> >
> > What is the best way to do this?

>
> That depends on te format of the text/paragraphs in the mysql field.
> How are the paragraphs separated ?
>
>
>
> regards,
> Ewout

[Jason Wong]

On Tuesday 29 July 2003 04:16, John wrote:

> I'm using someone elses data here (inheriting). But it looks like it was
> typed into the field, possibly using PHPMyADMIN. I would assume the
> paragraphs are just seperated by carriage returns. Is there a way to tell
> for sure?

Yes, examine the contents.

--
Jason Wong -> Gremlins Associates -> [url]www.gremlins.biz[/url]
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
[url]http://marc.theaimsgroup.com/?l=php-general[/url]
------------------------------------------
/*
I don't want to be young again, I just don't want to get any older.
*/