Page 1 of 1

How to query for last 5 item entries

Posted: Tue Sep 29, 2009 9:14 am
by edawson003
I have form on my site, where a user can enter and item into my sql table. I figured out how to display the last item entered by the user. How can I display the last 5 items entered?

Code: Select all

$lastresult = "SELECT itemname, itemid FROM Lib WHERE createdby = $id AND creatdt = (SELECT MAX(creatdt) FROM Lib WHERE createdby = $id) GROUP BY itemname, itemid";

Re: How to query for last 5 item entries

Posted: Tue Sep 29, 2009 9:22 am
by papa
ORDER BY 'date' DESC LIMIT 5

Re: How to query for last 5 item entries

Posted: Tue Sep 29, 2009 8:35 pm
by edawson003
Bingo! That worked. Thx!