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";Moderator: General Moderators
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";