Code: Select all
SELECT * FROM messaging INNER JOIN messaging_subject ON messaging.subject_id = messaging_subject.subjectID WHERE messaging.user_id = '$userID' GROUP BY messaging.conversation_id ORDER BY messaging.date_sent DESC Moderator: General Moderators
Code: Select all
SELECT * FROM messaging INNER JOIN messaging_subject ON messaging.subject_id = messaging_subject.subjectID WHERE messaging.user_id = '$userID' GROUP BY messaging.conversation_id ORDER BY messaging.date_sent DESC