> I tried with both \n, which > was balnk, and \n'n, which returned the entire text. Perhaps because it should be \n\n, not \n'n? Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Lisi" <lists@shemeshdirectory.co.il> To: "heilo" <grillen@abendstille.at>; "PHP-DB" <php-db@lists.php.net> Sent: Tuesday, 27 May, 2003 03:02 Subject: Re: retrieving first paragraph I'm still getting the entire text when I echo $paragraphs[0], and $paragraphs[1] is empty (I thought the array was supposed to have the whole text, and then the individual selected parts). I tried with both \n, which was balnk, and \n'n, which returned the entire text. Any ideas why? Thanks, -Lisi At 12:02 PM 5/26/03 +0200, heilo wrote: >hi! > >afaik limiting the query may get quite complicated, using those >string-operators. in php just do it this way: > > // depending on your $excerpt you have to use \n\n or only \n > $paragraphs = preg_split('#([^\n]+)(\n\n)#mi', $excerpt); > echo $paragraphs[0]; // contains first paragraph > >hope this works. > >.ma > >Lisi <lists@shemeshdirectory.co.il> wrote@26.05.2003 12:07 Uhr: > > > I have a table column that stores a few paragraphs of text. I want a > > preview page that retrieves the first paragraph, and then links to the full > > text on another page. > > > > 1) Can I limit this in the MySQL query? > > > > 2) If not, how would I select all text up until the first \n? I so far have > > > > ereg("(.){1,}\n", $text, $excerpt); > > > > I want the parentheses to capture the text up until the \n in the variable > > $excerpt, and then stop there. > > > > How do I do this with ereg? > > > > Thanks, > > > > -Lisi > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php