I want to create contact list like on facebook using php and mysql. I have table messages (values: ID | From | To | message_body | date | status), but i don't know how to get message sender id (value "from") just one time. Anyone can help?
Here is an example of what I think you're looking for...
SELECT DISTINCT `From`
FROM `messages`
WHERE `To` = `current_user_id`