How to query for last 5 item entries
Posted: Tue Sep 29, 2009 9:14 am
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";