You want to include an ORDER BY and order by a specific field in DESCending order, e.g.
Code:
SELECT * FROM diary_contents ORDER BY date_field DESC LIMIT 1;
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --