Hi,

Tried executing the query as follows from the command prompt:

SELECT COUNT(*), password FROM webmail_msgtrack,webmail_msgs, webmail_users WHERE msgtrack_mid = msgs_mid AND userid = msgtrack_userid AND UNIX_TIMESTAMP(msgs_sent) > users_last_login AND email = 'mymail@domain.com' AND msgtrack_status = 'New' GROUP BY email;


Result: Empty set (0.00 sec)

There is a New Message (not unread message) though but the query does not reflect that.

Any Suggestions

Thnx

Anup

Anup