I would like every page to be the results of all games on day "x".
Example:
OnthispageonlythegamesonJune6,2017,butallgamesinthetableareappearing.OBS*:Iamarrangingtheproformatdatesday/month/yearatthetimeofthedisplay.
I'musingthiscode,butit'snotorganizing.Datesarestoredasfollowsinthecolumn:year/month/day
$query=$conn->prepare("SELECT * FROM resultados ORDER BY rodada DESC LIMIT $inicio, $per_pagina");
$query->execute();