Last records

[leebo]

Is there a way of finding the last 10 records added to the database or records added in the last 14 days etc.. either way will do !

In ASP i would have used:

<%datenow = DateAdd("D", -14, date)
date3= FormatDateTime(datenow,vbshortdate)
date2= year(date3) &"/"& month(date3)&"/"&day(date3) %>

<%RS.Open "SELECT * FROM table1 WHERE date => '" & date2 & "' order by date", con, 3, 3 %>

Thanks

[Kevitt]

Well... This query will select table entries from withing the last 14 days. Assuming that your date_column is a datetime type.

SELECT * FROM `TBL_NAME` WHERE TO_DAYS(NOW()) - TO_DAYS(date_column) <= 14