Search next date in database

Question

I am creating a mysql table containing the date of an event. The question is as follows: if on the present day there is an event it is highlighted otherwise indicates the day of the next event. would they have any idea how to do it? The query for the current day would be more like searching for the following if it does not have the current day.

$data_atual = date('Y-m-d');
$resultado_evento = mysql_query("SELECT * FROM agenda WHERE data like '%$data_atual%'");
while($linhas_evento = mysql_fetch_array($resultado_evento)) {
    echo "nome " . $linhas_evento['nome'] . "<br>";
}

Answer 1

Use greater equal and set a limit to 1, if you have an equal date today, show it, or show the next date. Don’t forget to give an ORDER BY by the date.

$data_atual = date('Y-m-d h:i:s');
$resultado_evento = mysql_query("SELECT * FROM agenda WHERE data >= '$data_atual' ORDER BY data ASC LIMIT 1");