Jump to content

retrieving latest info


sugoi_kat
 Share

Recommended Posts

i'm just wondering if it was possible to use SQL to retrieve the latest information.Part of the database has to retrieve the last exercise the student has completed regardless of when they completed it, in other words, user's don't specify a date.The date of when this exercise is completed is going to be placed on the form along with the name of the exercise.

Link to comment
Share on other sites

i'm just wondering if it was possible to use SQL to retrieve the latest information.Part of the database has to retrieve the last exercise the student has completed regardless of when they completed it, in other words, user's don't specify a date.The date of when this exercise is completed is going to be placed on the form along with the name of the exercise.

Just get all records (or limit 1) and order them descending by date. The first record will be the most recent.
Link to comment
Share on other sites

  • 2 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...