Stuck with MySQL

[Kinneh]

Help me 🙂

I have a mysql database for a clan website. I want to show what the highest scoring game is. I have 2 fields called Opponent and Our_Score. I need to find the highest score in the Our_Score field and then display what the score was and who it was against(opponent) on the website.

Help would be great thanks!

[Kinneh]

bump

[Remote4ever]

select max(our_score), opponite,
from (whatever table)
(you will need a where statement that is something like this so you dont get the highest score from one match, and a random score from another match of the other team)
where our_score = '9-15-2002 and Opponites='9-15-2002';

I THINK!

[TTT]

nope... remote4ever...
select max(id) as id, parent from table group by parent
... work's also and gives highest id from every parent-group

but if you don't use max(id) as id then result colum doesn't get name at all