Envoyé par
Dinan
1 2 3 4 5 6 7
| SELECT g.id AS g_id, b.id AS b_id, g.title AS g_title, b.title AS b_title, b.body, COUNT(t.id) AS nb_t, COUNT(m.id) AS nb_m, t.title AS t_title, t.id AS t_id, m.id_user AS m_id_user, m.id AS m_id
FROM ilya_board AS b
INNER JOIN ilya_board_group AS g ON (b.id_group=g.id)
LEFT JOIN ilya_topic AS t ON (t.id_board=b.id)
LEFT JOIN ilya_message AS m ON (m.id_topic=t.id)
GROUP BY b.id
ORDER BY g.ORDER ASC, b.ORDER ASC, t.uptime DESC |
c'est ce que j'ai fait, mais il ordonne pas ...
ORDER BY g.ORDER ASC, b.ORDER ASC, t.uptime DESC
Tu aurais pas oublié tes champs derrière les alias de tables? dans le genre:
ORDER BY g.nomchampg ASC, b.nomchampb ASC, t.uptime DESC
C'est juste une question comme ça par hasard...
Partager