Karaethon Posted April 1, 2019 Share Posted April 1, 2019 Is it (I'll bet the anwer is Yes) possible to SELECT the oldest entries in the table? "SELECT * FROM `vaults` WHERE `Status` = "Unsolved" ORDER BY `CREATED` LIMIT 75 Would this be correct? Quote Link to comment https://forums.phpfreaks.com/topic/308536-selecting-oldest-entries/ Share on other sites More sharing options...
requinix Posted April 1, 2019 Share Posted April 1, 2019 Does it work? Quote Link to comment https://forums.phpfreaks.com/topic/308536-selecting-oldest-entries/#findComment-1565756 Share on other sites More sharing options...
Karaethon Posted April 2, 2019 Author Share Posted April 2, 2019 It seems to, except it doesn't like the limit statement. If I have the limit it barfs... Quote Link to comment https://forums.phpfreaks.com/topic/308536-selecting-oldest-entries/#findComment-1565797 Share on other sites More sharing options...
requinix Posted April 2, 2019 Share Posted April 2, 2019 What does the error message say? Quote Link to comment https://forums.phpfreaks.com/topic/308536-selecting-oldest-entries/#findComment-1565798 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.