>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 way would be to include a date stamp on the article 
(which i see you already have, and assuming you have done it in mysql 
friendly - "Y-m-d H:i:s" then you can do this and get them in reverse 
chronological order (newest article first)

select * from articles order by date desc limit 7
and on the "archive page"

select * from articles order by date desc limit ,7 or something like that, 
see the mysql documentation under the select syntax

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to