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
Last records
Moderator: General Moderators
you didn't mention what DB
so i will assume mysql
select * from table order by date desc limit 10
which will take the last 10 (limit 10) records order by date from latest to earliest (desc)
hth
select * from table order by date desc limit 10
which will take the last 10 (limit 10) records order by date from latest to earliest (desc)
hth
-
laserlight
- Forum Commoner
- Posts: 28
- Joined: Wed Jan 01, 2003 6:41 am