1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| <?php
$query = $this->db->query('
SELECT
M.*, membres.username
FROM
mps M
LEFT JOIN membres U ON U.id = M.id_expediteur
LEFT JOIN membres U2 ON U.id = M.id_destinataire
WHERE
(M.id_destinataire = '.$this->session->userdata('user_id').' AND M.id_expediteur = '.$idmembre.')
OR (M.id_destinataire = '.$idmembre.' AND M.id_expediteur = '.$this->session->userdata('user_id').')
ORDER BY
M.id_message DESC');
foreach ($query->result() as $obj)
{
echo "Id membre: ".$obj->id." - Pseudo : ".$obj->username." - Message : ".$obj->content."<br>";
}
?> |
Partager