Selecting the latest article from an archive

[wellbeing]

Hi,

I'd like to keep editorials in a table with just two columns (date, editorial) and:

1. Display the latest editorial on the home page
2. Archive the remaining articles (without the latest one) on another page.

Any ideas?

Thanks in advance.

[davieboy]

mysql_connect($db_host,$db_user,$db_pass);

mysql_select_db ($db_name) or die (mysql_error());

$result = mysql_query("SELECT *  FROM table ORDER BY id DESC LIMIT 1")or die (mysql_error()) ;

the other

mysql_connect($db_host,$db_user,$db_pass);

mysql_select_db ($db_name) or die (mysql_error());

$result = mysql_query("SELECT *  FROM table ORDER BY id DESC LIMIT 20")or die (mysql_error()) ; //Enter your limit instead if 20

I am going to be looking up the next // previous links tuts, so news can be broken into pages of say 5 or so.

That coding should do though

[wellbeing]

I tried this and it works perfectly. Thank you!