dc_jt Posted June 21, 2007 Share Posted June 21, 2007 Hi heres the scenario: There are 3 documents 1,2 and 3 Person A completes document 1 on 1/1/2007, document 2 on 2/1/2007 and document 3 on 3/1/2007 Therefore, completes them all by 3/1/2007 Person B completes document 1 on 4/1/2007, document 2 on 2/1/2007 and document 3 on 3/1/2007 Therefore, completes them all by 4/1/2007 This is held in a table like id person_id document_id date_completed How do I order them by who completed them all first? Hope someone can help Thanks Quote Link to comment https://forums.phpfreaks.com/topic/56545-getting-latest-date/ Share on other sites More sharing options...
trq Posted June 21, 2007 Share Posted June 21, 2007 SELECT * FROM tbl ORDER BY date_completed DESC Quote Link to comment https://forums.phpfreaks.com/topic/56545-getting-latest-date/#findComment-279262 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.