I have a blog-type site Running PHP 4.3.1 and MySQL where I will be updating the homepage on a regular basis. When the page is updated I want the old entry to go to an Archive page that will show all entries except the latest one (because it is on the home page). I thought of using LIMIT, but it is used more for what you want to include rather than what you don't want to include. The table has fields for a unique id, a date/time stamp that is recorded when the entry is created, an entry title and the entry text. Does anyone have any suggestions on what sort of query I would use to get the Archive page to show all entries except the last one created?
Thank you for your help.