[RESOLVED] Show part of a long article and show all the article in a different page

[bprof]

Hi,

I've created a php script that reads from a DB an article, but instead of showing the whole article, I just want part of it to appear on a page and the rest on a different page:

text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text ...more

When I click on more I will be able to get the whole article.

Can someone help me with that?

Thanks a lot

[bradgrafelman]

You'd create a preview page, and use SUBSTR() to have the DB only return part of the article. Create a more link with something like "?action=more&id=$article_id" added to the URL.

Then, on the 'more' page, you'd simply retrieve the entire article from the DB.

[bprof]

Thanks so much bradgrafelman.

It worked with a little problem, and that is part of the word show:

i.e:

$art=SUBSTR($art, 0, 200);

shows:

text text text text text text text text text text text text text text text text text text text te

Is there a way to force it to include the whole word and not just part of it?

Thanks again,

[NogDog]

See my reply in this current thread.

[bprof]

Thanks a lot NogDog, thats solved it.