ORDER BY sql question

[jbachris]

First off, I was hoping for some help with my order clause in the following code:

$arse_score_rs = $conn->Execute ( "SELECT COUNT(goal.goal_id) as arse_goals, team.team_id, matches.match_id, goal.team_id FROM matches, team, goal WHERE goal.goal_side=1 AND matches.match_id=goal.match_id GROUP BY team.team_id ORDER BY matches.match_id DESC LIMIT 1" ) or die ( $conn->ErrorMsg() );

I'd like the ORDER BY to be ORDER BY matches.match_id DESC and then goal.goal_time ASC. How can I get this to work?

[stewartship]

TRY:

...ORDER BY matches.match_id DESC, goal.goal_time ASC"

as the end of the query.

Dont use a limit of 1 (unless of course you only want one result!)

[jbachris]

stewartship > thanks.

my query wasn't even right to begin with, i'm having problems figuring that out, it's kind of tricky.

basically, the goal of that query is to COUNT(goal.goal_id) for the most recent match. right now, as is, it is displaying all goals, regardless of the match. how can i get it to do display ONLY goals from the most recent match (sorted by date)?