[SQL] ricercare data più recente

[DragonFire]

al momento sto facendo le prove sul phpmyadmin di altervista...

SELECT O.OpponentName AS hometeam,
LM.LeagueMatchHomeGoals AS goals_home,
DATE_FORMAT(LM.LeagueMatchDate, '$print_date') AS date
FROM tplls_leaguematches LM, tplls_opponents O
WHERE
... ...
LM.LeagueMatchDate = (select max(LeagueMatchDate) from tplls_leaguematches)  
ORDER BY LM.LeagueMatchDate DESC 

cosi intendi


ps. volevo far un'altra domandina intanto. avendo acquisito in php la data, come faccio a farla avanzare di una settimana?