Re: retrieving first paragraph

or you could try combining them, make a \r\n

Hi! it is possible that your database does not return \n as a line break but \r it is also possible that the linebreak contains both \r\n but i don't think that this is for your case, cause it should have worked... first just try \r instead of \r again first with only \r and then again with \r\r perhaps this solves your problem? .ma -----Original Message----- From: Lisi <lists@shemeshdirectory.co.il> To: heilo <grillen@abendstille.at>, PHP-DB <php-db@lists.php.net> Date: Tue, 27 May 2003 09:02:25 +0200 Subject: Re: [PHP-DB] 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

Met vriendelijke groet, Fedde van Feggelen ~ There's always a way out ~