list of users

[tlacmen]

at first, I m sorry for my english (I m from czech republic)
I have a question:
in DB I have messages and user list and I want to get list of users, which send message to me ($SESSION["id"]) or which I send message to him?
I tryed: "select * from users left join messages on messages.to=$SESSION["id"] or messages.from=$_SESSION["id"]" but it return me too much of lines.
help me please!

[Sxooter]

tlacmen;10879439 wrote:

at first, I m sorry for my english (I m from czech republic)
I have a question:
in DB I have messages and user list and I want to get list of users, which send message to me ($SESSION["id"]) or which I send message to him?
I tryed: "select * from users left join messages on messages.to=$SESSION["id"] or messages.from=$_SESSION["id"]" but it return me too much of lines.
help me please!

Add a where clause, not in the join clause.

select * from users left join messages
on (messages.uid=users.id)
where messages.to=$_SESSION['id']

or something like that.