Da li ovo valja?
Kôd:
SELECT *
FROM (
SELECT users.username, users.image, messages.message, messages.sender, message_discussion.mid
FROM message_discussion, messages, users
WHERE messages.disc_id = message_discussion.mid
AND (
users.id = message_discussion.user_1
OR users.id = message_discussion.user_2
)
AND users.id != '2'
AND (
message_discussion.user_1 = '2'
OR message_discussion.user_2 = '2'
)
ORDER BY messages.timer DESC
) AS tabler
GROUP BY tabler.mid DESC
Mada ni ovo ne radi savrseno... mislim da ce morati da se doda jos jedno polje u tabelu za diskusije, sa vremenom slanja poruke/zapocinjanja diskusije, i to polje bi se apdejtovalo pri slanju svake nove poruke, a onda bih valjda, konacno, mogao da sortiram poruke po vremenu???