-Mensagem Original-
De: Matthew Cothier [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: quarta-feira, 28 de fevereiro de 2001 13:13
Assunto: [PHP-DB] Selecting number of news items on frontpage
I have a homepage which has a news headline system. Bascially via form the
admin of the site
I have a homepage which has a news headline system. Bascially via form the
admin of the site can submit news which appears on the front page, the only
problem is the news just keeps coming and I have a front page with too many
headlines on.
How can I make it so that say 7 articles appear on
Hey,
If you're using Mysql to store the items, you could
use the Limit statement to limit the number of items
displayed. If you're using the file system it'd
probably be a little more difficult, but not
impossible. For example, if the news items were stored
in a text file with one entry per
Matthew,
Do you want to be told how, or want to read an interesting article on just
this, including PHP script to build your archives. It's one of the early
PHP tutorials -- try a search on "php movie database".
I adapted code from that for my own archive, although I run a shell script,
have a look at the page.
Regards - Miles
At 10:28 PM 2/28/01 +, Matthew Cothier wrote:
From: [EMAIL PROTECTED] (Miles Thompson)
To: [EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: Re: [PHP-DB] Selecting number of news items on frontpage
Date: Wed, 28 Feb 2001 17:06:07 -0400
Matthew,
Do you
You could then issue as select statement like " select * from articles
limit 7 order by nArticleKey descending" (maybe it should be "top"
instead of "limit", check your MySLQ syntax) and feed those to the front page.
select * from articles order by nArticleKey desc limit 7
although a better
