[PHP-DB] Re: Storing last access From: Hugh Bothwell (hugh_bothwell <email protected>)
Date: 07/30/01

"Olinux O" <olnx <email protected>> wrote in message
news:20010730093853.62929.qmail <email protected>
> 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. 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>