find last two records

[noodleweb]

Hi guys, problem,
need to display last two records inserted into a database by date.two tables are joined by common columnname
whats the best way to do that?
using cf7 and mysql
:confused;

[mxstu]

One way is to sort the records by the date column in DESCending order, so the
most recent are listed first. Then grab the first 2 rows. I don't know the
exact syntax, but look in your documentation for the LIMIT command. It should
be something like this

--- NOT tested
SELECT t1.SomeColumn, t1.SomeOtherColumn
FROM table1 t1 INNER JOIN table2 t2 ON t1.CommonColumn = t2.CommonColumn
ORDER BY t1.yourDateColumn DESC
LIMIT 2