Member Avatar for JackieW

I've got a *very* simple form, one field. I want a person to be able to go in and update a single number. (example: '10 are signed up of 100 entries' - with 10 being the form number) I only want the most recent number to show up, not the previous numbers. (example: I don't want yesterday's 9 to show up once I put in today's 10)

Right now I've got it set up in a typical Do, While, Wend loop, but of course that isn't going to work. Is there a simple, quick way to pull only the most recent number and display only that number from a database?

  • 2 Contributors
  • 2 Replies
  • 102 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by JackieW
Member Avatar for umairraja52

You can get latest records or updated latest records through time function, create time/date field in your database.

When you retrive data then use time with current time to retrive latest record.
Thanks

Member Avatar for JackieW

Thanks! Worked like a charm.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.