Arrange pagination

Question

I’d like every page to have the results of every game of "X" day. Example:

On this page only the games of June 6, 2017, but is appearing all the games of the table. OBS*: I am organizing the dates pro format day/month/year at the time of the exhibition.

I’m using this code, but it’s not organizing. The dates are stored like this in the column: year/month/day

$query = $conn->prepare("SELECT * FROM resultados ORDER BY rodada DESC LIMIT $inicio, $per_pagina");
$query->execute();