in reply to Re: Re: Re: Database setup for daily db
in thread Database setup for daily db

Hey,

How would I use the timestamp way?

would it fit this format:

Click on the date you want to view data for

Dates:
10/08/02
10/09/02
10/10/02
etc...

Then if the user clicks 10/08/02 the data for that day would show up

Data for 10/08/02:

Anthony Jones
John Doe
Robert Jones
etc...

Anthony
  • Comment on Re: Re: Re: Re: Database setup for daily db

Replies are listed 'Best First'.
Re: Re: Re: Re: Re: Database setup for daily db
by zigdon (Deacon) on Oct 09, 2002 at 00:30 UTC

    yah, it should be able to do that. Each day, you add the entries of that day to a table, with a stamp of the day (say, 20021008 for 10/08/2002). When you want to see the available dates, you just do a SELECT DISTINCT Date FROM Table. Then, when you want to see the entries for 10/08/2002 day, just do a SELECT Users FROM Table WHERE Date=20021008.

    Note that I'm not a database guru, but this should give you an idea how to proceed.

    -- Dan