only show 10 newest records 2

[florens]

Hi there,

I'm quite new to PHP, but I am trying to build a site which shows news items(which I insert myself). I store the newsitems in a database. I can extract the news items from the database but I only want the newest 10 to be shown on the site. The others should be archived in the database and remain accessible.

Does anyone know how to do this?

 

[jgd12345]

First you'll need to add the field ie dateline (int - 10) to the table. Then you need to give each news post a date/time when you insert them. I prefer to use unix timestamps simply put $thetime = time();

Then use that variable in the relative place of the insert statement ie:

mysql_query("INSERT INTO news_posts VALUES('', '$thetime' ...)"

Now to query the last 10 records you would put

$query = mysql_query("SELECT * FROM news_posts LIMIT 0, 10"

while($post = mysql_fetch_array($query)) {
// Content
}

 

[philclare]

in your select query do

SELECT * FROM newstable ORDER BY newsdate LIMIT 10

Hope this helps,

Phil Clare

http://www.trinipoint.co.uk

 

[jgd12345]

Ooops I missed an important bit change:
$query = mysql_query("SELECT * FROM news_posts LIMIT 0, 10"

to:
$query = mysql_query("SELECT * FROM news_posts ORDER BY dateline DESC LIMIT 0, 10"

 

[florens]

Thanks for your reply's.
I'm unable to test it right now, but I will test it asap and keep you posted.

 

[florens]

It works like a charm, thanks again.