Re: Storing last access

"Olinux O" <olnx@yahoo.com> wrote in message news:20010730093853.62929.qmail@web11803.mail.yahoo.com... > Hi all, > I would like to display messages that are entered into > a database since the last time i checked it. [Much > like web based email marks NEW messages.] > > What is the best way to do this? By adding an > additional column to the Messages Table OR creating a > new table with the field "Table_Name" and > "Last_Checked" Adding a field to the table is a single-user solution; if you want this useable by more than one person, a second table is needed. There are two ways of going about this; if you want to know whether individual messages are read or not, you will have to keep individual user/message records; if all you want is messages since a given date, you can just add a 'last-read' timestamp to your users table.