Page 1 of 1

Last records

Posted: Mon Dec 30, 2002 9:33 am
by 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

you didn't mention what DB

Posted: Wed Jan 01, 2003 12:54 pm
by lostboy
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

Posted: Thu Jan 02, 2003 4:39 am
by laserlight
hmm... but leebo wants the last 10 in the database, not just a table.

Maybe a join of all the tables in the database could be made, then such a query?
I havent quite experimented with joins yet.

Posted: Thu Jan 02, 2003 3:02 pm
by leebo
Thanks guys i have now sorted it