omega2 | --stan-- a écrit a écrit :
Code :
- select a.pseudo as pseudo_top ,a.last_poster as last_poster, a.sujet as sujet, a.id as id, a.max(page) as maxpage, b.pseudo as pseudo_rep, c.email as email from topics a, reponses b, membres_ob c where a.email_rep = '1' or b.email_rep = '1' and a.id = b.topic_id and (a.pseudo = c.pseudo or b.pseudo = c.pseudo)"
|
pk ce ki est en rouge fait bugge la rekete ?
|
tu peux faire un max un min ou autres opérations du genre, que si tout les autre champs retourné dans ta requête sont regroupé grace à un group by.
Dans ton cas, ca donne :
select a.pseudo as pseudo_top ,a.last_poster as last_poster, a.sujet as sujet, a.id as id, a.max(page) as maxpage, b.pseudo as pseudo_rep, c.email as email from topics a, reponses b, membres_ob c where a.email_rep = '1' or b.email_rep = '1' and a.id = b.topic_id and (a.pseudo = c.pseudo or b.pseudo = c.pseudo)
group by pseudo_top ,last_poster, sujet, id, pseudo_rep, email
|
