Display latest published story

ehmer

I wish to display a news story on a page when the user follows the link 'latest news'. Each story is identified by a number which is generated when it is added to the database (eg 8)

I have a date field in the database called 'published'. Currently my script reads as follows and displays the nominated story (ie 8) if a specific story link is not clicked to get to this page.

<?php if (!$id) {
$id = "8";
}
?>

I would like my script to default to displaying the most recently published story.
Appreciate suggestions for how this could be done.

http://www.acpchnqld.org.au/news_archive.php

David

drawmack

there are two very simply ways to accomplish this.

1) auto number field

ALTER TABLE news ADD COLUMN anID BIGINT NOT NULL auto_increment

then just use a query like this to get the most recent article:

SELECT * FROM news ORDER BY anID DESC LIMIT 0,1

The first result is the most recently entered.

2) Convert that date field into a timestamp.

ALTER TABLE news CHANGE COLUMN published, published TIMESTAMP NOT NULL

now on your inserts let the published field auto populate it will populate with now.

then select the most recent story like so:

SELECT * FROM news ORDER BY published DESC LIMIT 0,1