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. 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 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? 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
Archived
This topic is now archived and is closed to further replies.