c_pattle Posted October 15, 2010 Share Posted October 15, 2010 I have the following mysql query "select * from articles where article_number=12;" The article number field auto_increments. Is there an way to find out if the article number specified in the query is the most recent entry. So for example if there were 12 entries in the database this would be the most recent one? Thanks for any help. Quote Link to comment https://forums.phpfreaks.com/topic/215981-mysql-find-most-recenty-entry/ Share on other sites More sharing options...
litebearer Posted October 15, 2010 Share Posted October 15, 2010 perhaps using ORDER BY article_number DESC LIMIT 1 might do it Quote Link to comment https://forums.phpfreaks.com/topic/215981-mysql-find-most-recenty-entry/#findComment-1122621 Share on other sites More sharing options...
Pikachu2000 Posted October 16, 2010 Share Posted October 16, 2010 Your question isn't very clear. What are you attempting to do? Quote Link to comment https://forums.phpfreaks.com/topic/215981-mysql-find-most-recenty-entry/#findComment-1122808 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.