Re: [PHP] check unread messages in a forum

2002-08-26 Thread Eric Pignot
the method explained by Stas is the most common method used on all boards. But if you need a more precise method, that will also require more ressources from you server, what you can do is have a specific DB table called "msg_read" taking 2 parameters : msg_id, user_id. - Each time a user reads a

Re: [PHP] check unread messages in a forum

2002-08-26 Thread Eric Pignot
the method explained by Stas is the most common method used on all boards. But if you need a more precise method, that will also require more ressources from you server, what you can do is have a specific DB table called "msg_read" taking 2 parameters : msg_id, user_id. - Each time a user reads a

Re: [PHP] check unread messages in a forum

2002-08-26 Thread Stas Maximov
Hi, Just store the user's last log-in date/time either in the database or in cookie. On the next log-in "select * messages where creationDate > $userLastLoginDate" and highlight those selected. It won't work for every particular unread message, but I doubt if one needs to be that much specific.

RE: [PHP] check unread messages in a forum

2002-08-26 Thread Matt Schroebel
> From: Charlotte [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 26, 2002 8:04 AM > To: [EMAIL PROTECTED] > Subject: [PHP] check unread messages in a forum > > > I have made a forum in PHP, and the users are logged in using > cookies. I > want all new threads (and if there are new replies i