It occurred to me after my first reply that you might be able to do something in mysql.
This works (given my earlier assumptions): select left( paras, if ( locate( '\n', paras ) = 0, length( paras ), locate( '\n', paras ))) ... It will work with \n\n as well. 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
