showing date,today yesterday ....

[mrcniceguy]

In my website i want to introduce a link where people will see who joined the site for example today,yesterday one week ago,2week ago and one month ago...
how i`m i going to do this in php?

[logic_earth]

If you add a date_when_joined field in your table that would be a start.

[mrcniceguy]

yes i add date as timestamp,so whats next?

[funkdaddy]

Are you just going to run a script saying, show me all users within last X days/weeks/month?

Do you mean "last week" as in 7 days ago, or the last Sunday-Sat? Are these all going to be on one page? Some people could be duplicated as they were signed up both last week and last month... and many people could be for both last month and last week, 2 weeks, etc. What should you do with duplicates?