show first and show second

[Anon]

ok I want to display news of a database, now in one table I want to show the most recent one (no problem with that) but in another table of the page want to show only the second last entry.
how can I do that?

[Anon]

here is the code. do I have to change anything in the "for" section?

$result = mysql_query("select * from ph24_news order by date desc limit 3") or die ("could not read news database");
$num =mysql_num_rows($result);

for ($i=0 ; $i<$num; $i++)
{

$titel = mysql_result($result, $i, "titel");
$text = mysql_result($result, $i, "text");
$url = mysql_result($result, $i, "url");

[thoand]

In your SQL statment
... order by date desc limit 1,1

eg. [LIMIT [offset,] rows]

see also: http://www.mysql.com/doc/S/E/SELECT.html