Discussion :

[bndd24]

Salut à tous,

Comment trier les résultats (order by) dans un UNION.. ? voici mon code :

Code php :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
 
$stmt = $pdo->prepare("
SELECT r.id, r.message, r.send_id, r.received_id, r.received_at
FROM received r
WHERE r.received_id = $received_id AND r.send_id = $send_id
 
UNION
 
SELECT s.id, s.message, s.send_id, s.received_id, s.send_at
FROM send s
WHERE s.send_id = $received_id AND s.received_id = $send_id");
 
$stmt->execute();

Merci pour votre aide

[bndd24]

j'ai trouvé tout seul

voici la solution :

Code php :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
 
$stmt = $pdo->prepare("SELECT * FROM 
(SELECT r.id, r.message, r.send_id, r.received_id, r.received_at
FROM received r
WHERE r.received_id = $received_id AND r.send_id = $send_id
 
UNION
 
SELECT s.id, s.message, s.send_id, s.received_id, s.send_at
FROM send s
WHERE s.send_id = $received_id AND s.received_id = $send_id) AS msg ORDER BY id");
 
$stmt->execute();