[RESOLVED] Determining recentness of table rows

[system_critical]

Hi,

Is there a built in SQL statement that allows you to get the most recent row via time-stamp or do you have to painstakingly compare date() with the date in the DB? Thanks.

[dagon]

order by date limit 1

[NogDog]

dagon;10892052 wrote:

order by date limit 1

To get the most recent:

. . . ORDER BY date_or_timestamp_field [color=red]DESC[/color] LIMIT 1

[dagon]

NogDog;10892059 wrote:

To get the most recent:

. . . ORDER BY date_or_timestamp_field [color=red]DESC[/color] LIMIT 1

Thats what i said 😃

[HalfaBee]

You missed the DESC and returned the first record. 😉

[system_critical]

Thank you both. That helps a lot.