suzzane2020 Posted February 2, 2007 Share Posted February 2, 2007 hi, hw can i select the latest 10 job postings from my table datewise? 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 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. 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 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
Archived
This topic is now archived and is closed to further replies.