I am trying to list some dates in "reverse" order, but unsure what code I should be using.
At present, the dates appear with the oldest first, newest at the end. My current code is:
{
$get_matches = mysql_query("
SELECT O.OpponentName AS hometeam,
OP.OpponentName AS awayteam,
LM.LeagueMatchHomeGoals AS goals_home,
LM.LeagueMatchAwayGoals AS goals_away,
LM.LeagueMatchID AS id,
DATE_FORMAT(LM.LeagueMatchDate, '$print_date') AS date
FROM tplls_leaguematches LM, tplls_opponents O, tplls_opponents OP
WHERE O.OpponentID = LM.LeagueMatchHomeID AND
OP.OpponentID = LM.LeagueMatchAwayID AND
(O.OpponentID = $team2search OR OP.OpponentID = $team2search) AND
LM.LeagueMatchSeasonID = $season2search
ORDER BY LM.LeagueMatchDate",$connection)
or die(mysql_error());
}
Any help would be greatly appreciated.
