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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
