Jump to content

Finding the password of a user on a particular day


thecard

Recommended Posts

I have a standard table full of users, there are a few fields: id, user, pass, email...

These are filled in when a user registers/changes personal information.

What I need is to work out the most elegant way that I can store the "personal" information of each user everyday at a certain time. This is so that I can then submit a query for instance to find out what a user's password was on the 16th of November 2009 or what his/her email address was 100 days ago.

 

Thanks for ANY help.

I really just can't get my head around it.

Right.

I'm sorry.

I shouldn't have used the example of passwords.

I don't want to know my users' passwords EVER.

I'm sorry! What I should have stated is that on the website there is a point system: I need to record the number of points each user has on every single day.

What is the best way of laying out my database to do this?

Do I have a table for points then have a field called "date"?

Pretend I didn't make the other post, I must have been mental at the time.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.