i need a line of php for picking out the new messages a user has received since his last visit, i got a $userlastvisit variable wich is updated once the user logs in, but i can't figure out the line i need for $msgnew. Any help appreciated

Reply

Hello?

Please, i need to know and i can't figure it out.

I thought of one thing, but it would require yet another field in my userstable :X
$qry=mysql_query("SELECT messages where username='$user' and savetime='$userlastvisit'");

but i don't think that works....aaaaaaarggh, please help

Reply

What I would do is to have a field in the table for the messages that says if it has been read or not (like a boolean field), and then when the user reads the message it would update the table and change it to read. Then you could have it count the number of messages that haven't been read that way.

Reply

Yea that could actually work just the way it should be, thanks!

Reply