JLitkie Posted July 17, 2010 Share Posted July 17, 2010 I am trying to write a script that pulls my most current invoice from the data base for a client. I am not sure exactly how to do it. I got everything in order but how to do that. I cannot release the coding because of financial sensativity, however if some one can just point me in the right direction on that coding piece I would be very appreciative. Quote Link to comment https://forums.phpfreaks.com/topic/207999-return-most-current-date/ Share on other sites More sharing options...
Pikachu2000 Posted July 17, 2010 Share Posted July 17, 2010 SELECT `field1`, `field2`, `field3`, `date_field` FROM `table`ORDER BY `date_field` DESC LIMIT 1 Quote Link to comment https://forums.phpfreaks.com/topic/207999-return-most-current-date/#findComment-1087330 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.