display "second latest" data from mysql

[boho]

Hi,

I need help with displaing the second latest text in the database. I have a date field and text field. I could use current date -1 or smth, but i will have multiple entries in one day, not 1 entry a day.

I thought displaing them by ID, so the second latest will be latest id -1, but I might be deleting entries, so id numbers won't be in the order.

I think the best way will be to sort by date and then tell the DB to display text with second latest date.

I can sort, but i do not know which code to use to make php to display text with second latest date.

I was thinking get a variable $lastdate, assign to it the last date, then tell php to get news with the date id < $lastdate and limit it to one.

Do You think thats a good solution?

Thanks in advance.

[devinemke]

SELECT * FROM table ORDER BY date DESC LIMIT 2

use the second row from the above query

[boho]

Thanks for the reply but how I will tell php to use second row.

Using your code i can get the php to echo:

Text1
Text2

So how i will tell to get rid of text1 and use only text2.

Is there echo "row2 only" command or something.
Do i need assign text to a variable and then echo it out.

Thanks for the help.

edit:

ok i thought about it and i think i can tell php to echo the text with the minimum date. I that what you are suggesting.

[devinemke]

the second argument to the [man]mysql_result[/man] function is the row offset.

[boho]

Thanks a bunch,

That's what i needed.