suzzane2020 Posted February 2, 2007 Share Posted February 2, 2007 hi, hw can i select the latest 10 job postings from my table datewise? Quote Link to comment https://forums.phpfreaks.com/topic/36748-solved-last-10-records-frm-database/ Share on other sites More sharing options...
HuggieBear Posted February 2, 2007 Share Posted February 2, 2007 Try This sql... SELECT * FROM table_name ORDER BY date_column DESC LIMIT 10 Regards Huggie Quote Link to comment https://forums.phpfreaks.com/topic/36748-solved-last-10-records-frm-database/#findComment-175258 Share on other sites More sharing options...
suzzane2020 Posted February 2, 2007 Author Share Posted February 2, 2007 thnx!! tht worked great. Quote Link to comment https://forums.phpfreaks.com/topic/36748-solved-last-10-records-frm-database/#findComment-175259 Share on other sites More sharing options...
HuggieBear Posted February 2, 2007 Share Posted February 2, 2007 Glad to be of assistance Huggie Quote Link to comment https://forums.phpfreaks.com/topic/36748-solved-last-10-records-frm-database/#findComment-175261 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.