1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| <?php
$sqlMessagesHistorique = "SELECT id, membreID, pseudo, pseudoDestinataire,
idDestinataire, DATE_FORMAT(date, '%d/%m/%Y %H:%i') AS date_message, message, repondu
FROM me
WHERE membreID ='".htmlentities($idEnvoyeur)."' AND idDestinataire = '".$membreConnecte."'
AND repondu IN (1,2)
UNION ALL
SELECT id, membreID, pseudo, pseudoDestinataire,
idDestinataire, DATE_FORMAT(date, '%d/%m/%Y %H:%i') AS date_message, message, repondu
FROM me
WHERE membreID ='".$membreConnecte."' AND idDestinataire = '".htmlentities($idEnvoyeur)."'
AND repondu IN (0,1,2)
ORDER BY id ASC";
?> |
Partager