"Olinux O" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
