Re: retrieving first paragraph

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 >