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