Hi i need to run a mysql query where I can find unread PM of a certain user(say userid=1). I would also like to get the userid and username of the user that the PM came from. The pm and pmtext table is lil confusing. I might have to use a join query.can someone help me with this?